Function Problem HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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)
 
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
Click to expand...
the BA11 cell is empty or blank. Can you assist with this
one.
 
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
Click to expand...

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
 
Also:

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

Sam said:
This function below is generating the #Value! error if the BA11 cell is
Click to expand...
empty or blank. Can you assist with this one.
 
Back
Top