Adding a Formula within an "IF" statement

Yellow_Cruzer

Hey there, I was wondering how I would tell the sheet to read a cell and IF the requirement is met it would generate a value otherwise, run a formula.

So something like, IF( "Total Deposit Paid" = 0 than generate "0" otherwise generate "=SUM([Gross Rent]@row - [Rent Credit]@row + [Rent Debit]@row)"

Thank you!

Paul McGuinness

Hi @Yellow_Cruzer

Based on the formula you wrote above I would write that as below,

IF([Total Deposit Paid]@row=0,0,SUM([Rent Credit]@row + [Rent Debit]@row)-[Gross Rent]@row)

Hope that helps

Thanks

Paul McGuinness

Paul McGuinness

Hi @Yellow_Cruzer

Based on the formula you wrote above I would write that as below,

IF([Total Deposit Paid]@row=0,0,SUM([Rent Credit]@row + [Rent Debit]@row)-[Gross Rent]@row)

Hope that helps

Thanks

Paul McGuinness

Yellow_Cruzer

That worked! Thank you!