-
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.
and statements
-
S
Hefty IF Statemnets
Hi There, I have an IF statement that currently has 10 IF statements within...- sbrittain1988
- Thread
- and statements excel if statements multiply ranges
- Replies: 1
- Forum: Excel Questions
-
L
Display Text IF Statement
I'm trying to display which quarter throuout a shift an error was made. I can get Q1 and Q2 to work but for whatever reason Q3 and Q4 returns #Value! as the result. Formula...- lmmorris
- Thread
- and statements if statements time convertion
- Replies: 2
- Forum: Excel Questions
-
A
IF/AND Statement with Multiple Conditions
Greetings, I could certainly use some expert help with this formula. I am trying to accomplish the following: If Cell H7 < 0, then put in "q" If Cell H7 is greater than 0 and less than 1, put in "u" If Cell H7 is greater than 1 and less than 5, put in "{" If Cell H7 is greater than 5, put in...- ACF0303
- Thread
- and statements if statements multiple condition multiple conditions
- Replies: 9
- Forum: Excel Questions
-
R
Nested IF Statement Not Working
I am having issues with the following if statement. E68 is a calculated result =IF(E68<1.01,1.01,E68), IF(E68>=1.04,1.04,E68) Essentially it is <1%=1% or >4%=4% (a minimum and a maximum) Thanks for any assistance you can provide.- rlc
- Thread
- and statements if statements
- Replies: 6
- Forum: Excel Questions
-
F
If/then statements in multiple cells
I'm trying to figure out how to write a formula for the following: I have data in cells d12, d13 and d14. If the number in each of those cells is 6.5 or higher then I need the words "Meets Criteria" to appear in cell d11; if the number is lower than 6.5 in any of those cells then the words...- Fredilev
- Thread
- and statements if statements logic formulas
- Replies: 7
- Forum: Excel Questions
