ExcelBanter - If number then... how?

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

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

- - If number then... how? (https://www.excelbanter.com/excel-programming/349892-if-number-then-how.html)

Ctech[_63_]

If number then... how?

Hi

Im trying to make this formula in Excel. But it needs some tweeking..

=IF(J1= a number, "YES")

how do I do the number part?

--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=499349

Roger Govier

If number then... how?

Hi

Try
=IF(ISNUMBER(J1),"YES","NO")

--
Regards

Roger Govier

"Ctech" wrote in
message ...

Hi

Im trying to make this formula in Excel. But it needs some tweeking..

=IF(J1= a number, "YES")

how do I do the number part?

--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread:
http://www.excelforum.com/showthread...hreadid=499349

Norman Jones

If number then... how?

Hi Ctech,

Try:

=IF(ISNUMBER(J1),"Yes")

---
Regards,
Norman

"Ctech" wrote in
message ...

Hi

Im trying to make this formula in Excel. But it needs some tweeking..

=IF(J1= a number, "YES")

how do I do the number part?

--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=499349

All times are GMT +1. The time now is 02:56 AM.