Posted to microsoft.public.excel.misc

Niek Otten Niek Otten is offline

external usenet poster

Posts: 3,440

Formula won't work

See answers to your earlier, similar post.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"George" wrote in message
...
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%, but it will not calculate
the
75% or 100%, 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
WHY doesn't formula work???	TSuraco	Excel Discussion (Misc queries)	5	November 28th 07 08:25 PM
Formula will not work	Indymanny	Excel Discussion (Misc queries)	6	May 15th 07 10:50 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
My formula won't work	Julie P.	Excel Worksheet Functions	2	June 21st 05 12:51 AM

All times are GMT +1. The time now is 01:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us