Tweak formula to ignore if blank.

[Livin404]

Greetings, I have a formula that is used with a VBA function; it works great but I'm getting #VALUE! for blank cells. The formula is

=GET30MINRANGE(B2)

. I am hoping I can adjust so it will ignore the blanks. Thank you.

 

[jasonb75]

Wrap the formula in IFERROR() ?

 

[Peter_SSs]

.. or possibly

=IF(B2="","",GET30MINRANGE(B2))

 

[Livin404]

Wrap the formula in IFERROR() ?

That worked fine just had to put ,”” towards the end.