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
Thank you so much for your help. Much appreciated.
Ushindi , 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.
CB2023 , you are welcome
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!!!
I guess something like
=IF(A1=9, A1-9, A1+1)in A2 and drag down, isn't it? Not sure about the chart, which one exactly you'd like to have?
- SergeiBaklan
If I may impose, I have a question, also.
I am trying to create a chart where each cell adds one to the previous, but if the previous is 9 you subtract 9.
Example: Cell A2 would be A1 plus 1, but if A1 is 9 subtract 9. And each to follow the same. How would I enter this?
Thank you in advance. I'd suggest you start new thread with this question and add small sample file to illustrate how exactly your data is structured. Or at least screenshots. I'm not sure I understand entire logic.
And if not me someone else will help with new thread.
SergeiBaklan Can you help me too please?
I have three worksheets- Worksheet 1 is to update total days worked per month for a particular role, worksheet 2 gives me capex% for that role and in worksheet 3 I have column for all roles and a column for opex/capex. Now in worksheet 3 , in separate col for a given month, I have to calculate total effort based on capex%.
If in worksheet 3, A1=role 1, find total days worked from worksheet 1 and multiply it with capex % in worksheet 2 if B1 in worksheet 1 is Capex, else it should calculate 100%- Capex% (from worksheet 2)
SergeiBaklan
Can you help me on this one
If column A contains "X" and Column B is > 3 , then Subtract "CONSTANT: 3" from the value of column B?
I feel like I am over complicating some steps but missing others.
Thanks!
