Forum Discussion
daniellew1217
Jun 03, 2022Copper Contributor
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!
- OliverScheurichGold Contributor
=IF(E2-25<=0,"NONE","STOP")
=MIN(B2:B3)*5
You can try these formulas which seem to work in my sheet.