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
Hi Guys, I wonder if someone can assist me with my problem. If Column A subtract Column B gives you a negative figure, I would like Column C to indicate "Short" - If it is over, I would like Column C to indicate "Over". How do I write this formula to give me this result.