| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple If Statements
I'm trying to return multiple results using IF function for the following.
If A1 is greater that 0.01 and less than 2.50 then enter 3.99, but if A1 is greater than 2.50 and less than 3.50 then enter 4.99. I can do it for one: =IF(AND(J22.50,J2<3.50),"4.99") But not multiples. Help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple IF Statements | Excel Discussion (Misc queries) | |||
| Multiple IF statements looking up multiple ranges. | Excel Worksheet Functions | |||
| multiple IF statements | Excel Worksheet Functions | |||
| Multiple if statements with multiple conditions | Excel Discussion (Misc queries) | |||
| Multiple IF Statements | Excel Discussion (Misc queries) | |||
Threaded Mode
