Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF/AND/OR Statements
Hi Guys,
Trying to figure this out, wondering if anyone could help me. I have three conditions with four different variables each, I'll describe below. Option 1 - Low Option 2 - Medium Option 3 - High These three conditions are in a dropdown box. The next thing I want to do is say in the following cell is: if low <= 1200, then use a cell, call it B1. if low 1201-1600, then use cell, call it B2 if low 1601-1800, then use cell, call it B3 and if low 1801-2400, then use cell, call it B4. if medium <= 1800, then use a cell, call it B1. if medium 1801-2400, then use cell, call it B2 if medium 2401-2700, then use cell, call it B3 and if medium 2701-3600, then use cell, call it B4. if high <= 2400, then use a cell, call it B1. if high 2401-3200, then use cell, call it B2 if high 3201-3600, then use cell, call it B3 and if high 3601-4800, then use cell, call it B4. Can anyone help?? Would be greatly appreciated ! |
#2
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
if or statements | Excel Discussion (Misc queries) | |||
if statements, and statements | Excel Worksheet Functions | |||
operator statements, shorting when reusing one of the statements? | Excel Programming | |||
If Then Else Statements | Excel Programming |