Forum Discussion
How to use the Subtract with IF function ?
Hi everyone, Actually, I need some help about How I can use subtract with IF function Or any other way ? For example: If A>0 , make (B - C). How I can use it on Excel, Please :)
Okay, I've updated the workbook with this formula in AV Balance cell.
=IF(D6>0,0,10000)
If you want to change the AV Balance, you can change it in the formula from 10000 to something else.
I hope this helps you
Regards
SergeiBaklan Please, would you be able to help me to populate column D using "if Formula".
Note: variance = Column C - Column B.
Many Thanks
- Thank you so much for your help. Much appreciated.
Ushindi , you are welcome
