G
gmannix1000
Hi Guys,
Trying to figure this out, wondering if anyone could help me.
I have three conditions with four different variables each, I'l
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
Trying to figure this out, wondering if anyone could help me.
I have three conditions with four different variables each, I'l
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