##### to be blank

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

I have this formula =K3-F3 if there is no value in the
cell it gives #### is it possible to have blank until a
value is entered please.

Thankyou
 
Hello from Steved

=IF(H3="","",K3-F3)produces a Circula Reference
but my cell goes blank, which is good but can the above
formula be devoloped to over come the Circular Reference
Please.

Thankyou
 
Hello from Steved

The below works great.
Question can it be developed one more stage.
In Cell F3 i've got 9:30 but K3 has no value,
hence could it still be possible to be blank please.


=IF(K3-F3=0,"",K3-F3)

Thankyou.
 
Hello from Steved

Please excuse me as I forgot to format the Column to Time
Format. Sorry it is fine as it is.

Thankyou.
 
Where are you putting the formula? You maybe have it in H3. As written, it has
to go in some other cells.
 
Back
Top