#1
|
|||
|
|||
Formula to enter value based on value of another cell
I am using Excel 2007 and Windows 7 Pro 64-bit. I need to create a formula based on the value of a different cell, i.e., I want to put a formula in B1 that is dependent on the value of A1: If the value of Cell A1 is 3.51 or higher, then the value of Cell B1 should be 6. If the value of A1 is between 0.00 and 3.50, the value of Cell B1 should be 12. Is this doable? Thanks in advance to anyone who takes the time to answer! |
#2
|
||||
|
||||
Hi and welcome to the board
In B1 try =IF(AND(A1>0,a1<=3.50),12,IF(A1>3.50,6,""))
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Perfect!
Works like a dream, thanks so much. Is there a Nobel prize for formulas?
|
#4
|
||||
|
||||
I wouldn't know about Nobel prizes, but this one is very basic.
Try to learn how it works , that will help in the future
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
formula |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to select cell based on formula | mreynolds1775 | Excel Programming | 4 | 09-22-2017 12:13 PM |
Auto enter data based on formula in another cell? | RonLEngle | Excel | 5 | 06-30-2017 11:44 AM |
Formula, Compare two cell's text and based on results output a number | Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
Creating formula based on if data is correct in cell | MattMurdock | Excel | 1 | 08-06-2012 03:11 AM |