conditional formula
 

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!
--
pattyling

conditional formula
 

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
"pattyling" wrote:

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!
--
pattyling

conditional formula
 

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?
--
pattyling


"Toppers" wrote:

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
"pattyling" wrote:

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!
--
pattyling

conditional formula
 

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

"pattyling" wrote:

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?
--
pattyling


"Toppers" wrote:

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
"pattyling" wrote:

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!
--
pattyling

conditional formula
 

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


"Toppers" wrote:

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

"pattyling" wrote:

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?
--
pattyling


"Toppers" wrote:

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
"pattyling" wrote:

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!
--
pattyling