Forum Discussion
CEOBlockchain
Dec 27, 2018Copper Contributor
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 :)
- Dec 28, 2018
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
CEOBlockchain
Dec 27, 2018Copper Contributor
Firstly, thank you for help my brother :).
Please check your file to fine What I need ?
Thank you again.
HAITHAM :)
Haytham Amairah
Dec 27, 2018Silver Contributor
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?
- CEOBlockchainDec 27, 2018Copper Contributor
Don't worry my brother.
Now, I hope to understand me Lol
I put example down :)
- Haytham AmairahDec 28, 2018Silver Contributor
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
- CEOBlockchainDec 29, 2018Copper Contributor
I'm sorry my friend, I want to ask you, please :)
=IF(D6>0,0,10000)
Can I add other same cell in this function ?