| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Avoiding #value
=IF(G12<0,G12*F12,"") - this formula works fine when the target cell
(g12) has a number in it or is blank. If, though, they have a space or letter, it gives the #value! What can I add to the formula to keep it from the #value! result? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Avoiding #value
=IF(AND(G12<0,ISNUMBER(G12)),G12*F12,"")
-- Regards, Peo Sjoblom Portland, Oregon "MicroMain" wrote in message ups.com... =IF(G12<0,G12*F12,"") - this formula works fine when the target cell (g12) has a number in it or is blank. If, though, they have a space or letter, it gives the #value! What can I add to the formula to keep it from the #value! result? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Avoiding #value
Thanks,
Works great |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Avoiding #NUM! | Excel Worksheet Functions | |||
| Avoiding the dreaded #div/0 error | Excel Worksheet Functions | |||
| vlookup avoiding #N/A | Excel Worksheet Functions | |||
| Avoiding typing similar formula 600 times | Excel Worksheet Functions | |||
| Macro avoiding circular reference | Excel Worksheet Functions | |||
Linear Mode
