Need help with a formula that is using data from 2 columns

MeganM

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))

Paul Newcome

Try this...

=[Building Turnover]@row + IF([Scheduled - Days Out]@row1< 30, 15, IF([Scheduled - Days Out1 > 45, 30))

Paul Newcome

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)))

Paul Newcome

Try this...

=[Building Turnover]@row + IF([Scheduled - Days Out]@row1< 30, 15, IF([Scheduled - Days Out1 > 45, 30))

MeganM

@Paul Newcome

=[Building Turnover]1 + IF([Scheduled - Days Out]1 < 30, 15, IF([Scheduled - Days Out1 > 45, 30)) returned "UNPARSEABLE"

Paul Newcome

My apologies. Missed a square bracket.

=[Building Turnover]1 + IF([Scheduled - Days Out]@row < 30, 15, IF([Scheduled - Days Out]@row > 45, 30))

MeganM

I realize now it is because I did not do my @row correctly. Thank you for your help!

Paul Newcome

Happy to help. 👍️

MeganM

@Paul Newcome Sorry, one last question...what if I wanted to change IF([Scheduled - Days Out]@row > 45, 30

to have >30<45?

Paul Newcome

I'm not sure I follow. Do you mean you want a 3rd output if it is between 30 and 45?

MeganM

no, just to change the 2nd

Paul Newcome

So you want to add 15 if less than 30, 30 if between 30 and 45 and then add nothing if greater than 45?

MeganM

now that you have opened Pandora's box I would like:

0-29 +15

30-44 +30

45-59 +45

>60+60

Paul Newcome

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)))