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

Options
✭✭

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

Tags:

• ✭✭✭✭✭✭
Options

Try this...

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Try this...

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

• ✭✭
Options

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

• ✭✭✭✭✭✭
Options

My apologies. Missed a square bracket.

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

• ✭✭
Options

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

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

• ✭✭
Options

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

to have >30<45?

• ✭✭✭✭✭✭
Options

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

• ✭✭
Options

no, just to change the 2nd

• ✭✭✭✭✭✭
Options

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

• ✭✭
Options

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

0-29 +15

30-44 +30

45-59 +45

>60+60

• ✭✭✭✭✭✭