ExcelBanter - IF function help

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF function help (https://www.excelbanter.com/excel-worksheet-functions/227273-if-function-help.html)

cjborntorun

IF function help

Hi - I currently have this formula:

=IF(T2<10,€Y€,€ €œ)

Problem is, if cell T2 is blank/null, I still get a €œY€, but I dont want
one. How can I enhance this formula so that it ignores null value in T2?

Thank you in advance for your help!

Dave Peterson

IF function help

=if(t2="","",if(t2<10, ....

cjborntorun wrote:

Hi - I currently have this formula:

=IF(T2<10,€Y€,€ €œ)

Problem is, if cell T2 is blank/null, I still get a €œY€, but I dont want
one. How can I enhance this formula so that it ignores null value in T2?

Thank you in advance for your help!

--

Dave Peterson

Mike H

IF function help

Hi,

Try this

=IF(AND(T2<"",T2<10),"Y","")

Mike

"cjborntorun" wrote:

Hi - I currently have this formula:

=IF(T2<10,€Y€,€ €œ)

Problem is, if cell T2 is blank/null, I still get a €œY€, but I dont want
one. How can I enhance this formula so that it ignores null value in T2?

Thank you in advance for your help!

cjborntorun

IF function help

Dave - Your suggestion worked. Thanks very much.

"cjborntorun" wrote:

Hi - I currently have this formula:

=IF(T2<10,€Y€,€ €œ)

Problem is, if cell T2 is blank/null, I still get a €œY€, but I dont want
one. How can I enhance this formula so that it ignores null value in T2?

Thank you in advance for your help!

All times are GMT +1. The time now is 01:24 PM.