Posted to microsoft.public.excel.worksheet.functions

Kristen PS Kristen PS is offline

external usenet poster

Posts: 1

Multiple IF statement

Hi,
I am trying to get a text response within a multiple IFF statement.
Basically, if the value in a cell is between 6 and 9 I want the formula to
return "drier than normal"
Between 10-14, "normal" 15-18 "wetter than normal.
This is the equation I have put together, but it keeps coming back "False"

=IF(AND(B45<9, B456), "drier than normal", IF(AND(B45<14, B4510),"normal",
IF(AND(B4515,B45<18), "wetter than normal")))
Any suggestions?
Thanks in advance!
Kristen

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
Multiple IF statement	Nikki	Excel Discussion (Misc queries)	5	February 26th 08 09:50 AM
Help with multiple If statement	Mike Busch[_2_]	Excel Discussion (Misc queries)	3	November 15th 07 04:33 PM
Multiple IF Statement	John	Excel Worksheet Functions	4	June 9th 07 02:33 PM
Multiple If Statement	TamIam	Excel Worksheet Functions	8	October 18th 06 08:55 PM
Help with a multiple OR statement.	Pank	Excel Discussion (Misc queries)	2	July 11th 06 03:10 PM

All times are GMT +1. The time now is 02:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us