#value ! ERROR IN CELL

Hi guys

i have 4 cells see below


Before temp entered

K15 L15 U15 AC7
Blank #VALUE! Blank Blank

After temp entered

K15 L15 U15 AC7
21.2 0.99230 0.99229 0.9929

The problem i have is L15 with the #VALUE! showing in cell L15 if no data is entered

K15 is a cell for users to enter a temperature

AC7 is a calculated cell based on what temp is entered in K15

U15 copies the result from AC7

L15 has a formula to round the figures from U15, the formula being "=IF(K15?=15,ROUND$U15,4),ROUND($U15,4))"

How can i change thins that the "#VALUE!" Error does not show in L15 even if no data is entered in K15
Any help appreciated
Scouse13

Try this:

=IFERROR(Old formula,"")

Originally Posted by Phuocam

Try this:

=IFERROR(Old formula,"")

What do you mean by old formula?

=iferror(if(k15=15,round($u15,4),round($u15,4)),"")