|
|
#1
12-06-2017, 08:10 AM
|
|||
|
|||
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!
|
| Tags |
| formula |
|
|
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 |
Windows 7 64bit 
Office 2007
Threaded Mode