Adding a Formula within an "IF" statement

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!

Find more posts tagged with

Formulas

IF(

Accepted answers

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.