Forum Discussion
How to use the Subtract with IF function ?
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,
Let me show you a simple example as follows.
=IF(A2>0,B2-C2,A2)
The above formula says:
IF cell A2 greater than 0, then subtract cell C2 from B2 and return the result.
Otherwise, return the value of cell A2 as it is.
Please check out this https://support.office.com/en-us/article/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2 to learn more about IF function.
Hope that helps
Firstly, thank you for help my brother :).
Please check your file to fine What I need ?
Thank you again.
HAITHAM :)
Hi,
Sorry for the late reply, but I didn't understand what you need!
Please tell me what the wrong in the formula or give me examples on some cases and what the formula should return in them?
Don't worry my brother.
Now, I hope to understand me Lol
I put example down :)
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