-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if less than or equal to
-
S
IF function not working correctly with calculated value
So I've run into a strange issue with using IF to compare whether one calculated value is less than or equal to another. The function works correctly in most situations, but in some cases it's incorrectly showing that the second calculated value is greater than the first when they are actually...- starryeyed223
- Thread
- if function if less than or equal to
- Replies: 4
- Forum: Excel Questions
-
A
If less than today() insert nothing ("") otherwise insert single space (" ")
I want to insert nothing if date is less than today otherwise a single space. I've tried if(B2>today(),""," ") and if(B2=today()-1,""," ") but not working. Please check https://docs.google.com/spreadsheets/d/1NbwmB_Vtgkcb7x8NyjpUIlzR-oIANyBSHjVbcOv5t-I/edit#gid=2114046438- asolopreneur
- Thread
- if formula if less than if less than or equal to insert single
- Replies: 6
- Forum: Excel Questions
-
F
Less than or equal to 3 variables
Hi, I am trying to write a formula in Excel 2k7 that basically states if an input is larger than "x" than this is the value but I have 3 variables. For example: Variables are 17000, 20100, 35500 (cells AH5, AI5 and AJ5, respectively) I am taking the value from a cell (d27) I would like a...- fizzle
- Thread
- if less than or equal to
- Replies: 6
- Forum: Excel Questions
