Forum Discussion

Copper Contributor

Sep 23, 2022

Excel formula

I have a spreadsheet. I need a formula to add 2 cells together, one of the cells will be a different cell depending if there is a value in another cell I have tried sumifs with the value for the 3rd ...

Formulas and Functions

dscheikey

Bronze Contributor

Sep 23, 2022

alifinn

=IFS(B1<0,SUM(A1,D1),B1>0,SUM(C1,D1),TRUE,0)

Last argument if b1 =0 then 0

alifinn
Copper Contributor
Sep 23, 2022
Thank you, it works if the value in B1 is more than 0, however if it is 0 or left blank then the answer is blank so I have to put in a minus value, tried changing the first part to B1BLANK but that didn't work
- HansVogelaar
  MVP
  Sep 23, 2022
  alifinn
  
  What do you want to return if B1 is blank? And if B1 contains 0?
  - alifinn
    Copper Contributor
    Sep 23, 2022
    if B1 is blank or 0 I want to return the sum of A1 and D1