I have the following formula but the result comes back as #value because the
cell is still blank.

Is there another formula that I could use so that I no longer get this error?

Thanks