IF information is in cell A8 then Formula is active?

L

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.
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top