Posted to microsoft.public.excel.worksheet.functions

JBoyer

external usenet poster

Posts: 72

Help with changing a formula

The current formula I have is...
=IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX (F:L,ROW()+1,)),"PENDING
CREDITS","")

I want to make one addition to this formula. Before it does my current
formula I want it to check if any cells in F:L,ROW() are <0, if they are i
want it to be blank, if not then I want it to perform my current formula.

THANKS IN ADVANCE!

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
changing formula	S S	Excel Worksheet Functions	6	August 30th 07 04:00 PM
how to edit formula without changing formula of each cell	sadat	Excel Worksheet Functions	2	April 24th 07 02:02 PM
Changing Formula	Secret Squirrel	Excel Discussion (Misc queries)	4	March 13th 07 08:10 PM
Changing formula to a value	newbie101	Excel Worksheet Functions	1	August 16th 06 02:19 PM
Copy Formula Down Without Changing Entire Formula	roy.okinawa	Excel Discussion (Misc queries)	3	March 16th 06 01:54 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us