IF/AND/OR Statements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top