I have tried a few formula's; however, none have worked properly, so I am asking here for help with it. What I need is to come up with a formula that can subtract the value of one cell from a previous cell: ex: M4=(K4-L4) After that, if cell M4 <= 0.8 then put a "1" in that cell (M4).
So if I have .76 in an o2 tank, then I want 1 to get ordered since the tank has 0.8 or less in it.
Any ideas are welcome and appreciated.
So if I have .76 in an o2 tank, then I want 1 to get ordered since the tank has 0.8 or less in it.
Any ideas are welcome and appreciated.