View Full Version : formula for logical condition
dpatel
02-08-2011, 03:17 AM
Hello,
As per attachment, i have package breakdown with individual cost per webcast.
i need a formula to calculate number of werbcast require * cost per webcast based on package.
Hope someone can assist me.
Thanks
here is the attachment
IBihy
02-08-2011, 06:29 AM
Hello,
in your workbook I changed the first column to hold only the lower limits of the package ranges, on cell D11 I inserted the formula =VLOOKUP(E10;A2:C6;3;TRUE)*E10 assuming that cell E10 will hold the value to look up packages for. The TRUE parameter does the trick. Excel help has a very good and easy to understand description of VLOOKUP.
Here's the table:
Package One Off Cost per webcast
1 500 500
2 1250 250
6 1500 150
11 3000 120
26 5000 100
Hope that's what you were looking for.
Have a nice day.
Isabella
IBihy
02-09-2011, 09:01 AM
Hello,
sorry for yesterday's sloppy answer, here's the working workbook attached below.
Have a nice day.
Isabella
tepkool01
02-09-2011, 12:48 PM
Gotta love vlookup!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.