conditional formula

[Guest]

I'm new at discussion groups - forgive me if I don't use correct wording.
I'm working w/ a payroll time sheet and want to use a conditional formula
that calculates and displays an amount only if there is worked hours in a
corresponding cell. Is this possible and if so, how do I set that up? I
need help A.S.A.P.!! Thanks a BUNCH!

 

[Guest]

General form will be along these lines:

in for example C1 put the following:

=IF(A1="","",A1*B1)

A1 = worked hours
B1=amount

If A1 is blank, leave result cell blank; otherwise multiply worked hours by
amount

Change cells to suit

HTH

 

[Guest]

A HUGE THANK YOU for answering so fast. I have another ? if I may: rather
than leaving amt cell blank - how can I have it display $0.00?

 

[Guest]

=IF(A1="",0,A1*B1)

A HUGE THANK YOU for answering so fast. I have another ? if I may: rather
than leaving amt cell blank - how can I have it display $0.00?

 

[Guest]

RIGHT ON!! I'm so glad I chose to sign up. Until next time....