Posted to microsoft.public.excel.misc

ladyhawk

Posts: n/a

formula error

Can anyone tell me what is wrong with the formula below:
=if(Data!AA910,Data!C92,(if(Data!AA910,Data!C85, (if(Data!AA780,Data!C78,(if(Data!AA710,Data!C71, (if(Data!AA640,Data!C64,(if(Data!AA570,Data!C57, (if(Data!AA430,Data!C43,(if(Data!AA360,Data!C36, (if(Data!AA220,Data!C22,(if(Data!AA150,Data!C15, Data!C8))))))))))))))))))

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
I get error with "ROWS" in the formula - nested formula question	Marie J-son	Excel Worksheet Functions	0	January 4th 06 01:55 PM
formula too long error	SB	Excel Discussion (Misc queries)	2	December 19th 05 09:56 PM
Simplifying array formula which evaluates as error.	Richard Buttrey	Excel Worksheet Functions	5	September 30th 05 02:35 AM
Formula syntax error - chinese and gibberish	Joshua Fandango	Excel Discussion (Misc queries)	3	March 29th 05 01:27 PM
Formula error...	Jambruins	Excel Discussion (Misc queries)	2	February 24th 05 09:57 PM

All times are GMT +1. The time now is 11:57 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us