Excel Help

groyle

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 !

KAGY

Just had a quick go at that, TBH I wasn't sure what you wanted. This mightn't be the best way to do it, but I tried to avoid array formula for you.