ExcelBanter - formula help

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formula help (https://www.excelbanter.com/excel-programming/384967-formula-help.html)

Lynne

formula help

I am still learning and I am trying to do the following if possible:

If J4 I4, then is it possible for the word alert or stop to appear in this
formula cell?
All help is greatly appreciated.
Thank you

Gary Keramidas

formula help

yes it is;

=IF(J4 I4,"Alert","")

--

Gary

"lynne" wrote in message
...
I am still learning and I am trying to do the following if possible:

If J4 I4, then is it possible for the word alert or stop to appear in this
formula cell?
All help is greatly appreciated.
Thank you

Vergel Adriano

formula help

Yes, try

=IF(J4I4, "ALERT", "OK")

"lynne" wrote:

I am still learning and I am trying to do the following if possible:

If J4 I4, then is it possible for the word alert or stop to appear in this
formula cell?
All help is greatly appreciated.
Thank you

All times are GMT +1. The time now is 10:14 PM.