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

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