| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Look UP and then caluclation with IS ERROR
Hello,
Please refer attached worksheet and advise a formula to lookup and then do a calculation and adding IS ERROR to it. Thanks heaps Excel Dumbo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look UP and then caluclation with IS ERROR
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 -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
|
|||
|
|||
|
@ Claus Busch
For your information, IFERROR is not available in Excel 2003 or versions prior to that one!! Quote:
|
|
#4
|
|||
|
|||
|
thanks kevin and claus
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error handling error # 1004 Run-time error | Excel Programming | |||
| Caluclation of depreciation | Excel Worksheet Functions | |||
| Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
| Excel caluclation setting reverts back to manual when I close Exce | Setting up and Configuration of Excel | |||
| How do I set up a min and max function in the same caluclation? | Excel Worksheet Functions | |||
Linear Mode
