Need help with a formula that is using data from 2 columns
I have a column called Building Turnover and Scheduled - Days Out. Schedule days out takes turnover - today to get a number. I want to see the value and if the value is <30, I want to add 15, if it is I want to add 30. I want all of that in another column Can you help?
=IF(OR([Scheduled - Days Out]@row1< 30, [Building Turnover]1+15), IF(OR[Scheduled - Days Out1 > 45, [Building Turnover]1 + 30))
Best Answers
-
Try this...
=[Building Turnover]@row + IF([Scheduled - Days Out]@row1< 30, 15, IF([Scheduled - Days Out1 > 45, 30))
-
No worries. It is just continuing the nested IF statements.
=[Building Turnover]1 + IF([Scheduled - Days Out]@row < 30, 15, IF([Scheduled - Days Out]@row < 45, 30, IF([Scheduled - Days Out]@row < 60, 45, 60)))
Answers
-
Try this...
=[Building Turnover]@row + IF([Scheduled - Days Out]@row1< 30, 15, IF([Scheduled - Days Out1 > 45, 30))
-
=[Building Turnover]1 + IF([Scheduled - Days Out]1 < 30, 15, IF([Scheduled - Days Out1 > 45, 30)) returned "UNPARSEABLE"
-
My apologies. Missed a square bracket.
=[Building Turnover]1 + IF([Scheduled - Days Out]@row < 30, 15, IF([Scheduled - Days Out]@row > 45, 30))
-
I realize now it is because I did not do my @row correctly. Thank you for your help!
-
Happy to help. 👍️
-
@Paul Newcome Sorry, one last question...what if I wanted to change IF([Scheduled - Days Out]@row > 45, 30
to have >30<45?
-
I'm not sure I follow. Do you mean you want a 3rd output if it is between 30 and 45?
-
no, just to change the 2nd
-
So you want to add 15 if less than 30, 30 if between 30 and 45 and then add nothing if greater than 45?
-
now that you have opened Pandora's box I would like:
0-29 +15
30-44 +30
45-59 +45
>60+60
-
No worries. It is just continuing the nested IF statements.
=[Building Turnover]1 + IF([Scheduled - Days Out]@row < 30, 15, IF([Scheduled - Days Out]@row < 45, 30, IF([Scheduled - Days Out]@row < 60, 45, 60)))
Help Article Resources
Categories
Check out the Formula Handbook template!
