Look UP and then caluclation with IS ERROR

[Excel Dumbo]

Hello,

Please refer attached worksheet and advise a formula to lookup and the
do a calculation and adding IS ERROR to it.

Thanks heaps

Excel Dumb

+-------------------------------------------------------------------
|Filename: LookUP and then do calculation with ISERROR.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=871
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Fri, 10 May 2013 06:05:55 +0100 schrieb Excel Dumbo:

Please refer attached worksheet and advise a formula to lookup and then
do a calculation and adding IS ERROR to it.

if you calculate the price per unit in column F it is much easier.
In F2:
=B2/(C2-D2)*(E2="RETAIL")

In B17 you need:

=IFERROR((VLOOKUP(A17,$A$1:$E$10,2,0)/(VLOOKUP(A17,$A$1:$E$10,3,0)-VLOOKUP(A17,$A$1:$E$10,4,0)))*(VLOOKUP(A17,$A$1:$E$10,5,0)="RETAIL"),"")


Regards
Claus Busch

 

[Kevin@Radstock]

@ Claus Busch

For your information, IFERROR is not available in Excel 2003 or version
prior to that one!!

Hi,

Am Fri, 10 May 2013 06:05:55 +0100 schrieb Excel Dumbo:
-

if you calculate the price per unit in column F it is much easier.
In F2:
=B2/(C2-D2)*(E2="RETAIL")

In B17 you need:

=IFERROR((VLOOKUP(A17,$A$1:$E$10,2,0)/(VLOOKUP(A17,$A$1:$E$10,3,0)-VLOOKUP(A17,$A$1:$E$10,4,0)))*(VLOOKUP(A17,$A$1:$E$10,5,0)="RETAIL"),"")


Regards
Claus Busch

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Excel Dumbo]

thanks kevin and clau

+-------------------------------------------------------------------
+-------------------------------------------------------------------