Previous Topic Next Topic

#value

Closed
boule11 Posts 1 Registration date Monday 10 February 2014 Status Member Last seen 10 February 2014 - 10 Feb 2014 à 05:03
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 11 Feb 2014 à 11:49
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 responses

Réponse 1 / 2
2011N2 Posts 13379 Registration date Saturday 29 January 2011 Status Security contributor Last seen 24 December 2016 39
10 Feb 2014 à 06:33
Hello,

Look at this : https://www.extendoffice.com/documents/excel/664-excel-display-hide-zeros.html

Gabriel.
boule11
10 Feb 2014 à 07:29
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.
Ambucias Posts 47312 Registration date Monday 1 February 2010 Status Moderator Last seen 28 March 2026 11,166
10 Feb 2014 à 07:51
Click in the cell with #value and delete or correct your formula error
Réponse 2 / 2
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
11 Feb 2014 à 11:49
Hi Boule11,

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

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