Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel 2003
i have created a table which has in A2 Hand Towels B2 has the value 1
quantuty C2 has 1 D2 has 1 and E2 has the total 3 i wish to create a situation in F2 where i will get a result which will be the total price, Hand Towels in A2 will have attached to it the price £0.75 for each towel in this cell and somehow a formula which will take the value in B2 C2 D2 and multiply by the curency value atached to Hand Towels in A2 how can i do this ?. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel 2003
Hi
Assuming you set up a list of items on sheet2 with Item name in column A and price per item in column B =IF(COUNT(B2:D2),SUM(B2:D2)*VLOOKUP($A2,Sheet2!$A: $B,2,0),"") -- Regards Roger Govier "strider" wrote in message ... i have created a table which has in A2 Hand Towels B2 has the value 1 quantuty C2 has 1 D2 has 1 and E2 has the total 3 i wish to create a situation in F2 where i will get a result which will be the total price, Hand Towels in A2 will have attached to it the price £0.75 for each towel in this cell and somehow a formula which will take the value in B2 C2 D2 and multiply by the curency value atached to Hand Towels in A2 how can i do this ?. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel 2003
Hi,
where is the price for hand towels located? On a different sheet or on the same sheet? Sounds like you data is laid out this way?: A B C D E F Hand Towels 1 1 1 =Sum(B2:D2) =.75*E2 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "strider" wrote: i have created a table which has in A2 Hand Towels B2 has the value 1 quantuty C2 has 1 D2 has 1 and E2 has the total 3 i wish to create a situation in F2 where i will get a result which will be the total price, Hand Towels in A2 will have attached to it the price £0.75 for each towel in this cell and somehow a formula which will take the value in B2 C2 D2 and multiply by the curency value atached to Hand Towels in A2 how can i do this ?. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |