Hi everyone struggling to make a formula work and would really appreciate some help. Below is what I need to do.
If cell A3 = “load” I need cell I3 to perform sum (I2+F3)
If cell A3 = “discharge” I need cell I3 to perform sum (I2-H3)
If cell A3 = “Clean” in need cell I3 to show Clean
I’m having trouble making all three work together in the same cell.
If cell A3 = “load” I need cell I3 to perform sum (I2+F3)
If cell A3 = “discharge” I need cell I3 to perform sum (I2-H3)
If cell A3 = “Clean” in need cell I3 to show Clean
I’m having trouble making all three work together in the same cell.