Forum Discussion
Solved
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
Thank you so much for your help. Much appreciated.
Ushindi , you are welcome
SergeiBaklan
Can you help me on this one
If column A contains "X" and Column B is > 3 , then Subtract "CONSTANT: 3" from the value of column B?
I feel like I am over complicating some steps but missing others.
Thanks!
