Forum Discussion
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 ...
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
What do you want to return if B1 is blank? And if B1 contains 0?
- if B1 is blank or 0 I want to return the sum of A1 and D1
- Thank you