#1
|
|||
|
|||
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.
|
#2
|
||||
|
||||
Try =IF(or(D97>=1.80,d97<=1.2499),d97,1.80)
__________________
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
|
|||
|
|||
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.
|
Tags |
excel 2013 formula |
|
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 |