Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-06-2017, 08:10 AM
onemorething onemorething is offline Formula to enter value based on value of another cell Windows 7 64bit Formula to enter value based on value of another cell Office 2007
Novice
Formula to enter value based on value of another cell
 
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
  #2  
Old 12-06-2017, 08:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula to enter value based on value of another cell Windows 7 64bit Formula to enter value based on value of another cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,655
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default

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
Reply With Quote
  #3  
Old 12-06-2017, 09:08 AM
onemorething onemorething is offline Formula to enter value based on value of another cell Windows 7 64bit Formula to enter value based on value of another cell Office 2007
Novice
Formula to enter value based on value of another cell
 
Join Date: Dec 2017
Posts: 2
onemorething is on a distinguished road
Default Perfect!

Works like a dream, thanks so much. Is there a Nobel prize for formulas?
Reply With Quote
  #4  
Old 12-06-2017, 09:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula to enter value based on value of another cell Windows 7 64bit Formula to enter value based on value of another cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,655
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default

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
Reply With Quote
Reply

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 to enter value based on value of another cell 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
Formula to enter value based on value of another cell Creating formula based on if data is correct in cell 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft