Posted to microsoft.public.excel.worksheet.functions

Gimpy815

Posts: n/a

ISBLANK

I have a formula in cell F9: =IF(D9=C9,"","NOT EQUAL"). It's working great.
Now I want a formula in the next column that will compute a percentage if
"NOT EQUAL" is returned by the first formula. I'm trying to use
=IF(ISBLANK(F9),"",IF("NOT EQUAL",((D9/C9)-100%)). It's not working. Help?

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
ISBLANK Formula Help Request	John C. Harris, MPA	Excel Worksheet Functions	4	July 22nd 05 10:06 PM
VLOOKUP & ISBLANK	P08254	About this forum	0	May 27th 05 04:21 AM
VLOOKUP & ISBLANK	P08254	About this forum	0	May 27th 05 03:42 AM
Conditional Formatting and ISBLANK	Amanda	Excel Worksheet Functions	3	January 20th 05 06:04 PM
Is there a function for "not isblank" (find a cell that has a val.	Jim	Excel Worksheet Functions	3	December 8th 04 07:29 AM

All times are GMT +1. The time now is 03:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us