Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Worksheet functions - Ajit11021225
I have workbook named News.xls with 3 sheets namely Pricelist, Muster and
Bill for the month of January, 2005. Muster contains presenty of each client, marked P for present & A for Absent A.....B.....C.....D..... Days Sun Mon Tue Wed Date 1 2 3 4 1 John P A A P 2 Lucy A P P A 3 Pricelist contains prices for news papers (amount in Indian Rupees) A.....B.....C.....D.......E.........F.......G..... ..H... Days Sun Mon Tue Wed Thu Fri Sat Times 5 4 4 4 4 4 3.50 Economic 9 2 2 2 2 2 9 Now I want to prepare bills in sheet "Bill". I want Excel to check first from Muster whether client is marked as "P" on 1st of Jan, 05 (Saturday), if so, he should take a price of Times newspaper for Saturday from sheet Pricelist i.e. Rs.5/-, if not, put 0.00, & so on.. Thus my sheet will show : A.....B.....C.....D.....E.......F......G.......H.. ....I..Total Days Sat Sun Mon Tue Wed Thu Fri Sat Date 1 2 3 4 1 John 4 5 4 4 4 0 0 4 25.oo Note : On Thu & Fri John was marked as "A" How can I perform this in sheet Bill. -- Knowldege is Power |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
worksheet functions | Excel Discussion (Misc queries) | |||
worksheet functions with dates | Excel Worksheet Functions | |||
How to call worksheet functions from Access ? | Excel Worksheet Functions | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |