Function Problem HELP!

[Sam]

This function below is generating the #Value! error if the BA11 cell is empty or blank. Can you assist with this one.

=IF(BA11=0,"0",((BA11>=1440)*BA11)

I know it's simple, but, I'm missing it all together

Thanks

 

[Norman Harker]

Hi Sam!

You could use:

=IF(BA11="","0",((BA11>=1440)*BA11))

Or

=IF(BA11="","",IF(BA11=0,"0",((BA11>=1440)*BA11)))

But why "0"?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi Sam
try
IF(BA11="","",IF(BA11=0,"0",(BA11>=1440)*BA11))

Note: I'm not sure you should return '0' as a string. maybe you should
use
IF(BA11="","",IF(BA11=0,0,(BA11>=1440)*BA11))

and this can be shortened to
IF(BA11="","",(BA11>=1440)*BA11)

 

[Jason Morin]

If I use your formula, I get "0" if BA11 is empty. But I
get #VALUE! if there is text in BA11.

You can change the formula so that if BA11 is empty,
equals zero, or contains text, then return 0 (zero,
not "0"), otherwise perform your calculation.

=IF(OR(BA11=0,ISTEXT(BA11)),0,(BA11>=1440)*BA11)

HTH
Jason
Atlanta, GA

-----Original Message-----
This function below is generating the #Value! error if

the BA11 cell is empty or blank. Can you assist with this
one.

 

[Ron Rosenfeld]

This function below is generating the #Value! error if the BA11 cell is empty or blank. Can you assist with this one.

=IF(BA11=0,"0",((BA11>=1440)*BA11))

I know it's simple, but, I'm missing it all together.

Thanks

Try this:

=IF(ISERROR(-BA11),"0",BA11*(BA11>=1440))

although I don't understand why you want the "0" as a string. If that is due to
a misunderstanding, then:

=IF(ISERROR(-BA11),0,BA11*(BA11>=1440))





--ron

 

[Aladin Akyurek]

Also:

=(N(BA11)>=1440)*N(BA11)

This function below is generating the #Value! error if the BA11 cell is

empty or blank. Can you assist with this one.