SUMIF Formula ?
Hello! I am trying to make the following formula. If "Actuals (CashInHand)" is greater than "Budget" list the overperformance difference in "OverPerformance". If there is an underperformance it should stay $0.00. In this case the overperformance is $1,185,852.00. Thank you for your help!
Best Answer

Hi @jelfner
You can write a the following formula in the row against January for OverPerformance
=IF([January]7 > [January]5, [January]7  [January]5, 0).
7 and 5 here are supposed to be the row numbers of where Actuals (CashInHand) and Budget.
Thanks,
Aravind
Reach out for any help on licenses, configuration, or training
Answers

Hi @jelfner
You can write a the following formula in the row against January for OverPerformance
=IF([January]7 > [January]5, [January]7  [January]5, 0).
7 and 5 here are supposed to be the row numbers of where Actuals (CashInHand) and Budget.
Thanks,
Aravind
Reach out for any help on licenses, configuration, or training

Thank you so much!
Help Article Resources
Categories
Check out the Formula Handbook template!