Posted to microsoft.public.excel.misc

crmulle

external usenet poster

Posts: 11

If Formula using Greater than / Less than

My formula is listed below. I would like the formula to look at cell f2 and
determine if it =3 than 1, <3 but =6 than 2, <6 but =9 than 3 and <9 but
=12 than 4. The formula is not working and I know it has something to do
with my logical test but i am not able to figure it out...any help would be
appreciated.

=IF(F2<=3,1,IF(F23<=6,2,IF(F26<=9,3,4)))

Carolyn

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 greater than	Mel[_2_]	Excel Worksheet Functions	2	July 25th 08 09:41 PM
Greater than or less than formula	Cindy	Excel Discussion (Misc queries)	3	March 18th 08 08:13 PM
Greater Than formula	ginasucasa	Excel Worksheet Functions	5	January 7th 08 08:41 PM
Greater than but less than formula	Storm	Excel Worksheet Functions	3	July 11th 07 07:50 PM
Greater than Less than formula	Help with Check Mark!!	Excel Discussion (Misc queries)	3	August 22nd 06 07:05 PM

All times are GMT +1. The time now is 05:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us