ExcelBanter - What Formula do I use?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - What Formula do I use? (https://www.excelbanter.com/new-users-excel/122578-what-formula-do-i-use.html)

Richard

What Formula do I use?

Hi,

I need a formula to tell me if the number in the cell, I designate, is
greater or smaller than 7. If it is greater than I want it to paste the word
over and if it is less than I want it to paste the words under. Is there a
formula? Please let me know.

Thank you

Bob Phillips

What Formula do I use?

=IF(A17,"Over",IF(A1<7,"Under",""))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

"Richard" wrote in message
...
Hi,

I need a formula to tell me if the number in the cell, I designate, is
greater or smaller than 7. If it is greater than I want it to paste the
word
over and if it is less than I want it to paste the words under. Is there a
formula? Please let me know.

Thank you

All times are GMT +1. The time now is 06:52 PM.