Forum Discussion

daniellew1217's avatar
daniellew1217
Copper Contributor
Jun 03, 2022

IFS or comparing cells

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!

Resources