Posted to microsoft.public.excel.worksheet.functions

reloanpro

Posts: n/a

Error in "IF" formula

Please help me to see the error in the following formula:

"=IF(G6=0.9<=1,E6*G6,IF(G6=0.75<0.9,(E6*G6)*1.05 ,IF(G6=0.6<0.75,(E6*G6)*1.1,IF(G6=0.45<0.6,(E6*G 6)*1.15,IF(G6=0.3<0.45,(E6*G6)*1.2,IF(G6=0.15<0. 3,(E6*G6)*1.25,IF(G6=0.1<0.15,(E6*G6)*1.3,0)))))) )"

The worksheet is returning FALSE to the very first argument, though there is
a value of 97% in G6. The value of 97% is coming from an INDIRECT formula
fetching data from another worksheet into G6.

Any help is 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
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Array formula returning wrong results	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	1	November 19th 05 10:29 AM
IF formula?	meris	Excel Worksheet Functions	1	September 6th 05 07:14 AM
Formula works in some cells, doesn't in other	Wowbagger	New Users to Excel	13	June 30th 05 03:21 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM

All times are GMT +1. The time now is 08:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us