IF ISBLANK Cyclical reference help

[D3mtro]

I have a spreadsheet that has a field for when a project is funded (H3) I am also auto-calculating when certain evens SHOULD happen to compare to when they actually do happen. So here is the problem.

A13=Calculated Date of when event should start
B14=Calculated Date of when event should end

H3= Actual Date of when event should end (if determined) otherwise blank if undetermined

so what I want is in cell B14 a formula that does the following

IF H3 is blank take A13+5 but if H3 is not blank use the date in H3

so I wrote a formula =IF(h3=ISBLANK,A14+5,H3)

however it errors out as a cyclical error and I am stuck....anybody have a resolution?

Thanks D3mtro

[AliGW]

Maybe this:

=IF(h3="",A14+5,H3)

[AliGW]

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

[D3mtro]

That worked, thank you...Didn't even think of using quotes to reference the empty cell. thank you

[AliGW]

Please update your forum profile as requested.