View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maggie1959 Maggie1959 is offline
external usenet poster
 
Posts: 1
Default How do I formulate total before Gst?

how do I formulate cells to get a total BEFORE gst was added? Example : item
cost 20.00 Gst 1.00 = 21.00 I have a columm for the "item cost" without gst
added...then a gst columm...is there a way to formulate the 'item cost "
cell so I don't have to subtract the gst total from the grand total every
time I enter a price? (Office 2007)