Posted to microsoft.public.excel.worksheet.functions

phuser

Posts: n/a

IF'S Blah

=IF(ISERROR(F16-K16),"",IF(SUM(F16-K160),"",SUM(F16-K16)))

Cells F16 & K16 can either contain a "Null String" ("") or a number created
from another IF statement , from these 2 Cells I need another calculation,
if the error "#Value" is made I want it to be blank, If the number is 0, I
want it to be blank, but if it's a number I want it to appear.

Any help is greatly appreciated

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
Automatically insert/delete rows to be x apart	Mr_Flibble	Excel Discussion (Misc queries)	5	February 17th 06 04:04 AM
Rankif?	Lee Harris	Excel Worksheet Functions	4	October 19th 05 11:16 PM
How to split up bulk text??????	DJS1234	Excel Discussion (Misc queries)	5	October 13th 05 05:17 PM
Using the IF function	fluci	Excel Discussion (Misc queries)	2	August 4th 05 05:09 PM
nowrap with text row	philosophology	Excel Discussion (Misc queries)	0	May 27th 05 08:57 PM

All times are GMT +1. The time now is 07:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us