Forum Discussion

CEOBlockchain's avatar
CEOBlockchain
Copper Contributor
Dec 27, 2018
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 :)
excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Dec 28, 2018

    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

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Dec 27, 2018

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 https://support.office.com/en-us/article/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2 to learn more about IF function.

 

Hope that helps

Abdul_Naveed192000's avatar
Abdul_Naveed192000
Copper Contributor
Feb 06, 2021

Haytham Amairah 

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

Resources