Posted to microsoft.public.excel.misc

Bob I

external usenet poster

Posts: 2,819

Formula Won't Work

Because in an IF statement, once the the test is TRUE, the Else is not
evaluated. Reorder your test with that in mind.

George wrote:

Hello, can someone please help me with the following formula;
=IF(F5<=2999.99,"25%",IF(F5=3000,"50%",IF(F5=500 0,"75%",IF(F5=7000,"100%"))))
For some reason it calculates the 25% and 50% correctly, but it won't
calculate the 75% or 100% at all, it just stays at 50%

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
Sorting the cells of a formula causes the formula to not work	Jake	Excel Worksheet Functions	3	January 31st 09 04:42 AM
Formula will not work	Indymanny	Excel Discussion (Misc queries)	6	May 15th 07 10:50 PM
FORMULA DOESN'T WORK	Loyd	Excel Discussion (Misc queries)	4	March 30th 06 06:17 PM
A search for $ in a formula use to work now it does not work	JuneJuly	Excel Discussion (Misc queries)	2	November 30th 05 10:13 PM
formula won't work	tink13ub	Excel Worksheet Functions	1	January 17th 05 06:59 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us