View Single Post
 
Old 12-06-2017, 08:10 AM
onemorething onemorething is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Dec 2017
Posts: 2
onemorething is on a distinguished road
Default 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!
Reply With Quote