PDA

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!