Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by gmannix1000 View Post
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 !
Hi, I'm not sure what you mean by "then use a cell". Could you explain a little more or ideally provide an example workbook?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Statements (Mutliple Statements) Deezel Excel Worksheet Functions 3 October 19th 06 06:13 AM
if or statements jimar Excel Discussion (Misc queries) 3 March 29th 06 03:38 PM
if statements, and statements Sum Limit and marking Excel Worksheet Functions 3 March 29th 06 03:25 PM
operator statements, shorting when reusing one of the statements? KR Excel Programming 1 August 4th 05 06:20 PM
If Then Else Statements DLS[_3_] Excel Programming 3 August 21st 03 09:33 PM


All times are GMT +1. The time now is 07:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"