I'm attempting to use the following formulas in one cell. They all work separately, but I can't figure out how to combine them. Can someone help please?
=IF(G14="A",H14,"")
=IF (H14="A", G14,"")
Otherwise =SUM(G14+H14)Thank you for your input.
1 Answer
Could you explain a bit about what the expected output is? You can nest IF statements but im not sure what your end goal is here
EDIT:
Gotcha I think this should do it..
=SUM(IF(G14="A", 0, G14) + IF(H14="A", 0, H14))This way your just summing the result of the two if statements. They check if the cell = 'A' and if so setting the value to 0, else they use the actual value of the cell.
9
