Posted to microsoft.public.excel.misc

Alex McKenzie

Posts: n/a

multiple if statements

Hi all
Thanks for help in the past

I have in cell A1 either an "L" or an "S"

If cell A1= "L" then I require the following formula
(which refers to other cells)
in cell A2

=IF(D9<E10,1,IF(D9<E11,2,IF(D9E11,3)))

but if cell A1="S" then I need a slightly different
formula

=IF(D9E10,1,IF D9E11,2,IF D9<E11,3)))

in cell A2

Many thanks in advance

Alex

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
how do I make multiple "if" statements	AccessNewbie	New Users to Excel	3	October 6th 05 12:18 AM
Multiple If Statements	excelrookie05	Excel Worksheet Functions	2	September 14th 05 02:19 PM
multiple if statements	ddepasquale	Excel Worksheet Functions	3	August 5th 05 09:55 PM
How to: Multiple "if" statements?	Hosh	New Users to Excel	2	June 29th 05 02:20 PM
Combining IF and multiple SUMIF statements, if A>0 & B is between	Lee	Excel Worksheet Functions	1	January 3rd 05 06:46 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us