Forum Discussion
IF Function
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% Ot...
The formula is:
=[@Variance]/[@2022]Everything else is inventing new mathematics.
Or you could trap the error:
=IFERROR([@Variance]/[@2022],"not computable")