Look UP and then caluclation with IS ERROR

E

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
+-------------------------------------------------------------------
 
C

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
 
K

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
E

Excel Dumbo

thanks kevin and clau

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top