#value
Closed
boule11
Posts
1
Registration date
Monday February 10, 2014
Status
Member
Last seen
February 10, 2014
-
Feb 10, 2014 at 05:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 11, 2014 at 11:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 11, 2014 at 11:49 AM
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.
=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
2011N2
Posts
13352
Registration date
Saturday January 29, 2011
Status
Security contributor
Last seen
December 24, 2016
39
Feb 10, 2014 at 06:33 AM
Feb 10, 2014 at 06:33 AM
Hello,
Look at this : https://www.extendoffice.com/documents/excel/664-excel-display-hide-zeros.html
Gabriel.
Look at this : https://www.extendoffice.com/documents/excel/664-excel-display-hide-zeros.html
Gabriel.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 11, 2014 at 11:49 AM
Feb 11, 2014 at 11:49 AM
Hi Boule11,
I always use the combo IF and ISERROR to remove error messages:
=IF(ISERROR(your formula),"",you formula)
I always use the combo IF and ISERROR to remove error messages:
=IF(ISERROR(your formula),"",you formula)
Feb 10, 2014 at 07:29 AM
Feb 10, 2014 at 07:51 AM