IFS or comparing cells

Copper Contributor

Good morning, I'm trying to set up a worksheet and have 2 different needs. I keep reading the formulas but don't want TRUE or FALSE to populate as the result..


I need:  a cell to subtract 25 from the cell above it. If 0 or a negative I want it to fill with NONE or STOP.

I then need to compare two cells; whichever is lower, I need to multiply it by 5.

I hope I made sense. Thank you!

1 Reply



 You can try these formulas which seem to work in my sheet.

if or comparing cells.JPG