ExcelBanter - Avoiding #value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Avoiding #value (https://www.excelbanter.com/excel-worksheet-functions/67234-avoiding-value.html)

MicroMain

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?

Peo Sjoblom

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?

MicroMain

Avoiding #value

Thanks,

Works great

All times are GMT +1. The time now is 07:06 PM.