Posted to microsoft.public.excel.worksheet.functions

MicroMain

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Avoiding #NUM!	Bruno Campanini	Excel Worksheet Functions	9	September 14th 05 02:34 PM
Avoiding the dreaded #div/0 error	Marie1uk	Excel Worksheet Functions	10	July 21st 05 10:49 PM
vlookup avoiding #N/A	Lillian Eik	Excel Worksheet Functions	6	July 6th 05 03:03 PM
Avoiding typing similar formula 600 times	Ian D. Weatherall	Excel Worksheet Functions	5	June 29th 05 06:51 AM
Macro avoiding circular reference	Kanga 85	Excel Worksheet Functions	3	June 15th 05 03:04 AM

All times are GMT +1. The time now is 02:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us