Posted to microsoft.public.excel.misc

George

external usenet poster

Posts: 347

Formual Won't Work

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
some help with an IF formual or something like it	Lost Will	Excel Worksheet Functions	4	November 19th 08 12:00 PM
Formual	Jodi	Excel Worksheet Functions	1	May 16th 07 01:03 AM
WHAT DOES FORMUAL =C8+ 15 DO	Tara	Excel Discussion (Misc queries)	1	January 4th 07 03:38 PM
Formual	Winnie	Excel Discussion (Misc queries)	1	November 13th 06 10:19 AM
Set Formual	Winnie	Excel Discussion (Misc queries)	2	November 13th 06 09:47 AM

All times are GMT +1. The time now is 12:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us