Forum Discussion
Brian_Sarpy
Jun 02, 2023Copper Contributor
Need Help with IF Formula in Calculated Column
Hi everyone! I am hoping you can please help me. I am calculating a burn rate in a SharePoint List in a calculated column (titled Burn). I am trying to return a blank value in the Burn column i...
- Jun 04, 2023
Hi Brian_Sarpy,
i am not sure, if i got your requirements correctly
Your formula=IF(ISBLANK([Funding Remaining (As of last invoice)]),"",[Funding Remaining (As of last invoice)]/AVERAGE([Aug '23 Invoice (Est.)],[Jul '23 Invoice (Est.)],[Jun '23 Invoice (Est.)]))
works fine for me without an error, except if all invoice columns are empty
If that is your issue, then you can just wrap your formula into another if clause and check if the sum of the invoice columns is greater zero
=IF([Jun '23 Invoice (Est.)]+[Jul '23 Invoice (Est.)]+[Aug '23 Invoice (Est.)]>0,IF(ISBLANK([Funding Remaining (As of last invoice)]),"",[Funding Remaining (As of last invoice)]/AVERAGE([Jun '23 Invoice (Est.)],[Jul '23 Invoice (Est.)],[Aug '23 Invoice (Est.)])),"")
Best Regards,
Sven
SvenSieverding
Jun 04, 2023Bronze Contributor
Hi Brian_Sarpy,
i am not sure, if i got your requirements correctly
Your formula
=IF(ISBLANK([Funding Remaining (As of last invoice)]),"",[Funding Remaining (As of last invoice)]/AVERAGE([Aug '23 Invoice (Est.)],[Jul '23 Invoice (Est.)],[Jun '23 Invoice (Est.)]))
works fine for me without an error, except if all invoice columns are empty
If that is your issue, then you can just wrap your formula into another if clause and check if the sum of the invoice columns is greater zero
=IF([Jun '23 Invoice (Est.)]+[Jul '23 Invoice (Est.)]+[Aug '23 Invoice (Est.)]>0,IF(ISBLANK([Funding Remaining (As of last invoice)]),"",[Funding Remaining (As of last invoice)]/AVERAGE([Jun '23 Invoice (Est.)],[Jul '23 Invoice (Est.)],[Aug '23 Invoice (Est.)])),"")
Best Regards,
Sven
- Brian_SarpyJun 04, 2023Copper Contributor