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
WoW! Thank you for the quick response. 😊 I was sitting here fiddling with it, not knowing you had responded. I came to the same--finally. LoL =IF(A1 = 9,9 - 9, A1 + 1)
Thank you so much!!!
CB2023 , you are welcome
Perhaps you may share small sample file to illustrate an issue? I particular, it's not clear what "any amount in G20 will be deducted" means.
- Thank you for replying.
For some reason those are not working for me. Let me explain a little more. In my spreadsheet, I have a cell (F24) to show money that is owed to me. IF there is an amount in F24, than any amount in G20 will be deducted until the amount in F24 = 0 (this amount will be displayed in I24)
BUT if the amount in F24 is less than the amount shown in G20, the difference should show G26.
If F24 is 0, then I24 should show 0 as well. No sure I understood the logic correctly, perhaps
=IF( F24 > 0, G20 - MIN(F24, I24), G20 ) or =G20 - MIN(F24, I24)*(F24>0)- Hello, I believe I may have a similar question - I have a spreadsheet started and I am trying to find a formula for this - If F24 is greater than 0, then I24 will subtract from G20 but only less than or equal to F24.