| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF information is in cell A8 then Formula is active?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF information is in cell A8 then Formula is active?
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 On Mar 5, 8:58*pm, LiveUser wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use the active cell in an Excel formula | Excel Worksheet Functions | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| Active Cell To Change Formula | Excel Discussion (Misc queries) | |||
| how to copy a trendline formula into an active cell ? | Excel Discussion (Misc queries) | |||
| Using cell information in formula? | Excel Worksheet Functions | |||
Linear Mode
