Formula Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pjscott - 04 Mar 2008 20:53 GMT

I'm working with payroll data. I have a formula that displays payroll data
that's based on a payroll date. Until the payroll date is reached the cell
reads FALSE. Is there a way to display a 0 instead? This is the formula
=IF(A30>=A36,SUM('3-15'!X38 +'3-15'!AB38 + '3-15'!AF38 + '3-15'!AJ38 +
'3-15'!BT38)). Cell A30 contains the current date.

I have another formula that adds the number of hours worked in the 2 pay
periods in the month. If the hours add up to <100 a message appears. The
problem is it's using the same cells to calulate the number of hours from the
formula in the above example. It's adding 2 cells with FALSE. Is there a way
using the formula below to display a blank cell? This is the formula:
=IF(B7+B8<100, "Worked <100 Hours.").

Thank for the help,

Paul

Reply to this Message

Dave Peterson - 04 Mar 2008 21:26 GMT

=if() has three parts. The condition; the value returned if the condition is
true and the value returned if the condition is false.

=if(logical_test,value_if_true,value_if_false)

=IF(B7+B8<100, "Worked <100 Hours.")
only has 2 conditions.

=IF(B7+B8<100, "Worked <100 Hours.",0)
has all 3.

Same with your first expression.

> I'm working with payroll data. I have a formula that displays payroll data
> that's based on a payroll date. Until the payroll date is reached the cell
[quoted text clipped - 12 lines]
>
> Paul

Signature

Dave Peterson

Reply to this Message

pjscott - 05 Mar 2008 16:46 GMT

Got it Dave. Thanks a bunch.

Paul

> =if() has three parts. The condition; the value returned if the condition is
> true and the value returned if the condition is false.
[quoted text clipped - 25 lines]
> >
> > Paul

Reply to this Message

Rate this thread: