IF Function

Copper Contributor

Please could someone help me with the correct IF Function I need to return the following in the % variance column:


If 2022 is blank or 0 return 100%

If 2023 and 2022 are blank or 0 return 0%

Otherwise return the result of the formula - variance column divided by 2022


 20232022Variance% Variance


Thank you

1 Reply


The formula is:


Everything else is inventing new mathematics.


Or you could trap the error:

=IFERROR([@Variance]/[@2022],"not computable")