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
Can you help me with this one.
IF(A2<B2, A2-B2,A2) this one works but I want to add this next function
IF(A2>=B2,"0"). The result says I already exceed 2 to 3 arguments.
Can you help me?
Tops_dc I am trying to do something along the lines of this but it does not seem to work for me.
I want a cell F17 to update if there is an entry in F35. I want the current value in F17 to subtract by the value in F35 and display the new total.
I tried to do a Conditional Format using the following, but it does not seem to work.
IF(F35>0,F17-F35,F17)
Is this even possible?
That's with VBA programming if you consider such option, formula will return circular reference error.
Even with VBA entire logic how to handle misprints is not clear. Let assume you have 200 in F17. In F35 10 is entered, F17 goes to 190.
Now you found in F35 it shall be 100, not 10. Correcting F35 on 100 we have 90 in F17. Not 100 as it shall be.
Ah, that makes perfect sense. I appreciate the response. I'm just starting to work with VBA and the greater functions of excel.
Thank you for your assistance!
