Dec 26 2018 04:40 PM
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 26 2018 07:15 PM
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 link to learn more about IF function.
Hope that helps
Dec 26 2018 08:48 PM
Firstly, thank you for help my brother :).
Please check your file to fine What I need ?
Thank you again.
HAITHAM 🙂
Dec 27 2018 08:19 AM
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?
Dec 27 2018 02:26 PM
Don't worry my brother.
Now, I hope to understand me Lol
I put example down 🙂
Dec 27 2018 08:11 PM
SolutionOkay, 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
Dec 29 2018 02:44 AM
That is right, great.
Thank you so much Mr.Amairah.
Best Regards
HAITHAM
Dec 29 2018 02:44 PM
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 ?
Dec 29 2018 08:07 PM - edited Dec 29 2018 08:08 PM
Hi,
Yes, you can do this by using OR function as follows:
=IF(OR(D6>0,D9>0),0,10000)
The above formula says:
If either cell D6 or cell D9 is greater than 0, then return 0, otherwise, show the AV Balance which is 10000.
Also, you can replace OR with AND function to check if both cells are greater than 0.
The difference is that AND requires both cells to be greater than 0 in order to return 0.
Regards,
Haytham
Dec 30 2018 10:17 AM
You can open my profile here and send me a private message.
Feb 05 2021 11:58 PM
Dear Sir,
Can I use multi-cell for calculation?
For Example
if A2=1.1 and C2=3 and D2=A and If Sum of L2 TO T2 > 40-F2-H2 Then Sum of L2 To R2 and if Sum Of L2 TO R2 > 40-F2-H2 then answae L2 To P2 otherwise sum of L2 TO N2
Also Sheet are Attached
please help me
Feb 06 2021 02:01 AM
That is the duplication of the question here https://techcommunity.microsoft.com/t5/excel/excel-working/m-p/2116269
Apr 27 2021 10:28 PM
Apr 28 2021 03:38 AM
Aug 12 2021 03:20 PM
@SergeiBaklan Please, would you be able to help me to populate column D using "if Formula".
Note: variance = Column C - Column B.
Many Thanks
Aug 14 2021 04:34 AM
Aug 14 2021 11:06 AM
Aug 31 2021 01:18 PM
@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!
Dec 27 2018 08:11 PM
SolutionOkay, 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