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,
Yes, you can do this by using OR function as follows:
=IF(OR(D6>0,D9>0),0,10000)
The above formula says:
If either cell D6 or cell D9 is greater than 0, then return 0, otherwise, show the AV Balance which is 10000.
Also, you can replace OR with AND function to check if both cells are greater than 0.
The difference is that AND requires both cells to be greater than 0 in order to return 0.
Regards,
Haytham
Can I talk to you in any app ?
You can open my profile here and send me a private message.