Formula Question

  • Thread starter Thread starter pjscott
  • Start date Start date
P

pjscott

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
 
=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.
 
Got it Dave. Thanks a bunch.

Paul


Dave Peterson said:
=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.
Click to expand...
 
Back
Top