SOLVED

# How to use the Subtract with IF function ?

Occasional 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 :)

20 Replies

# Re: How to use the Subtract with IF function ?

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.

Hope that helps

# Re: How to use the Subtract with IF function ?

Firstly, thank you for help my brother :).

Thank you again.

HAITHAM :)

# Re: How to use the Subtract with IF function ?

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?

# Re: How to use the Subtract with IF function ?

Don't worry my brother.

Now, I hope to understand me Lol

I put example down :)

best response confirmed by CEOBlockchain (Occasional Contributor)
Solution

# Re: 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

# Re: How to use the Subtract with IF function ?

That is right, great.

Thank you so much Mr.Amairah.

Best Regards

HAITHAM

# Re: How to use the Subtract with IF function ?

`=IF(D6>0,0,10000)`

Can I add other same cell in this function ?

# Re: How to use the Subtract with IF function ?

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

# Re: How to use the Subtract with IF function ?

Can I talk to you in any app ?

# Re: How to use the Subtract with IF function ?

You can open my profile here and send me a private message.

# Re: How to use the Subtract with IF function ?

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

# Re: How to use the Subtract with IF function ?

That is the duplication of the question here https://techcommunity.microsoft.com/t5/excel/excel-working/m-p/2116269

# Re: How to use the Subtract with IF function ?

Hi,
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?

# Re: How to use the Subtract with IF function ?

That is

``````IF(A2<B2, A2-B2,0)

or

=MAX(A2-B2,0)``````

# Re: How to use the Subtract with IF function ?

@Sergei Baklan Please, would you be able to help me to populate column D using "if Formula".

Note: variance = Column C - Column B.

Many Thanks

# Re: How to use the Subtract with IF function ?

That could be

``=IF(A3="Research", IF( ISBLANK(C3)*ISBLANK(B3), "", C3-B3), "")``

# Re: How to use the Subtract with IF function ?

Thank you so much for your help. Much appreciated.

# Re: How to use the Subtract with IF function ?

@Ushindi , you are welcome

# Re: How to use the Subtract with IF function ?

@Sergei Baklan
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!