Get instant live expert help on if else statement in r
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi, can you please help me with nested IF statement in Excel?
IF(A=1) else check next cell IF(B=1) else check next cell IF(C=1) then perform calculation.
Solved by C. C. in 19 mins
I need a nested IF formula. I want it to return a value if it meets one of 6 options. Here is my formula: =IF(R$4=$G39,$F153*$F$140,IF(R$4=$G39+$E$147,$F153*$F$147,IF(R$4=$G39+$E$143,$F153*$F$143,IF(R$4=$G39+$E$144,$G153*$F$144,IF(R$4=$G39+$E$145,$F153*$F$145,IF(R$4=$G39+$E$146,$F153*$F$146,0))))))
But it only returns the first one and everything else is 0.
Solved by G. H. in 28 mins
I have an IF statement. IF something is shown in a cell, then add 1 to cell G1, else keep current cell blank. How do you write that function?
Solved by X. E. in 19 mins
I want to have one of two results either the number is over 40 then show 40 if the number is less than 40 then show the number. the if statement is missing something because it is showing both numbers 40 and the number less than 40.
=IF(O4>$R$1,(O4-$R$1),40),IF(O4<$R$1,(C4+D4+E4+F4+G4+H4+I4),0)
Solved by B. H. in 28 mins
=IF(K168="","","Q"&INT((MONTH(K168)+2)/3)&"-"&YEAR(K168))
Above is my current formula, how do i add an else statement so if it returns an error it should just input whatever value is in cell k168
Solved by I. H. in 27 mins