Thread: How do I...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lee willis lee willis is offline
external usenet poster
 
Posts: 1
Default How do I...

1 am making a cheat sheet for sales tax in a1 i have the sales tax. a2 -
a1001 i have $.01 to $100.00. b2-b1001 i have the formula that says what the
tax is. so for $.01 to $.07 is $.00. $.08 to $.23 is $.01. My question is
how do set it up so on a diffrent page it would pull the info so the lay out
would be (A1) $.01 (B1)- (C1)$.07 (D1)$.00 (A2)$.08 (B2)- (C2)$.23 (D2)$.01
and so on. Can anyone help?