#value [Closed]

Report
Posts
1
Registration date
Monday February 10, 2014
Status
Member
Last seen
February 10, 2014
-
Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
-
Hi, am trying to correct a formula. Each time am using this formula:

=IFERROR(VLOOKUP(B15;'Liste des Prix Net'!$A$1:$B$8;2;0);(P15/Q15)*(L15/1000)

there is #value which appear if there is no result.

Can someone help? I need the cell empty if there is no calculation.

2 replies

Posts
13336
Registration date
Saturday January 29, 2011
Status
Security contributor
Last seen
December 24, 2016
37
Hi, thanks a lot for your reply. Unfortunately that's not the solution. It fact i want to remove the #value when there is no calculation done.
Posts
48090
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
October 22, 2020
10,890
Click in the cell with #value and delete or correct your formula error
Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
446
Hi Boule11,

I always use the combo IF and ISERROR to remove error messages:

=IF(ISERROR(your formula),"",you formula)