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

@daniellew1217 

=IF(E2-25<=0,"NONE","STOP")
=MIN(B2:B3)*5

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

if or comparing cells.JPG