View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vmohan1978 vmohan1978 is offline
external usenet poster
 
Posts: 38
Default Need Help with Formula-urgent

Page 2 (summary)
RAB No CERTIFIED QUANTITY OF STEEL IN MT
8mm 10mm 12mm 16mm 20mm 25mm

Sum 13.698 - - 49.710 109.236 -


Page 1
Received Dia Qty Rate difference

16 25 15000 25.00(forumla required)
16 42.5 12000 24.71it should shows(49.710-25) sa same dia
8 11 13000 11(it should show)
20 25.00 10250
8 8.50 11500 2.698(13.698-11( which is same dia as above)
20 16.37 13500
8 5.00 14800


summary may not necessary to be in Page-2 it may in page1 also

if not understood i will send my excel sheet please send me the e-mail id
my email id is