Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-12-2016, 10:51 AM
unknownhere2000 unknownhere2000 is offline Need a formula to set a field based on two variables Windows XP Need a formula to set a field based on two variables Office 2013
Novice
Need a formula to set a field based on two variables
 
Join Date: Jan 2016
Posts: 2
unknownhere2000 is on a distinguished road
Question Need a formula to set a field based on two variables


I want to create a formula that says, if a value in cell D97 <=1.2499 or if it is >=1.80, then give me the value in D97 else show 1.80.
Reply With Quote
  #2  
Old 01-12-2016, 12:41 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need a formula to set a field based on two variables Windows 7 64bit Need a formula to set a field based on two variables Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,484
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Try =IF(or(D97>=1.80,d97<=1.2499),d97,1.80)
Reply With Quote
  #3  
Old 01-12-2016, 01:05 PM
unknownhere2000 unknownhere2000 is offline Need a formula to set a field based on two variables Windows XP Need a formula to set a field based on two variables Office 2013
Novice
Need a formula to set a field based on two variables
 
Join Date: Jan 2016
Posts: 2
unknownhere2000 is on a distinguished road
Default Got it!

Thanks! For some reason, it thought when I was testing the formula and changing the amount in cell D97, it's contents was text. As long as it's a number, it worked fine.
Reply With Quote
Reply

Tags
excel 2013 formula

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array to iterate through variables and trap blank variables Marrick13 Word VBA 5 08-04-2015 06:19 AM
Creating new field in pivot table based off existing field laceymarie1987 Excel 0 06-26-2014 12:13 PM
Formula Field using Field Codes hunter2193 Word 3 04-05-2013 04:58 AM
Calculating a cell value based on many variables malawimick Excel 0 12-14-2011 05:29 PM
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:13 PM.


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