Microsoft Office Forums Formula to enter value based on value of another cell
 Register FAQ Search Today's Posts Mark Forums Read

#1
12-06-2017, 08:10 AM
 onemorething Windows 7 64bit Office 2007 Novice Join Date: Dec 2017 Posts: 2
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
12-06-2017, 08:30 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,655

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
12-06-2017, 09:08 AM
 onemorething Windows 7 64bit Office 2007 Novice Join Date: Dec 2017 Posts: 2
Perfect!

Works like a dream, thanks so much. Is there a Nobel prize for formulas?
#4
12-06-2017, 09:26 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,655

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 Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post mreynolds1775 Excel Programming 4 09-22-2017 12:13 PM RonLEngle Excel 5 06-30-2017 11:44 AM Offrddrver Excel 4 03-23-2016 11:32 PM Scoth Excel 4 10-25-2012 07:51 AM MattMurdock Excel 1 08-06-2012 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top