IF information is in cell A8 then Formula is active?

[LiveUser]

Wondering how to use an If function.

I have information in A8 and D8 has a formula.
It does not matter if the information is in A8, B8, or C8 just as long as
the information is there and if so, then D8's formula will work, otherwise
the formula returns nothing.

This formula is in D8.

=B8*CostperHour22.00-C8+D7

Thank you.

 

[Pete_UK]

Try this in D8:

=IF(AND(B8<>"",C8<>"",D7<>""),B8*CostperHour22.00-C8+D7,"")

Will return a blank cell if any of B8, C8 or D7 are blank.

I presume CostperHour22.00 is a named range you have defined.

Hope this helps.

Pete