My First Question

[Apexwolf]

I am relatively new to Excel (using it for the past year) and have an issue I cannot seem to find a solution to. "=IF((H12-H14)*1000<0,0,(H12-H14)*1000)" I have this equation in a cell when I use one of my dial indicators at work, the problem is I have a second dial indicator that reads backwards. So instead of having to manually flip both H12-H14 is there a way I can tell this cell which dial indicator I'm using and then it uses the correct formula? Let me know if my question is not clear. Thank you.

 

[Apexwolf]

Correct @dried1011. If I get a number less than 0 its just zero.

 

[dreid1011]

Correct @dried1011. If I get a number less than 0 its just zero.

Please mark the post with the formula you ended up using as the solution.

 

[Apexwolf]

That's just clicking the check mark on the side, correct?

 

[dreid1011]

That's just clicking the check mark on the side, correct?

Yes