View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Need Assist With Formula Creation

Try these:

H1: =G1*0.8
J1: =G1*0.2 + I1

Hope this helps.

Pete


On Dec 28, 2:27*pm, Rick wrote:
I'm using Office 2000 Pro (Excel) and usually do okay with formulas but I am
stuck with the following: *
G1 = $amt
H1 = G1 less 20%
J1 = G1 less 80% + I1 * (I1 = $amt)

Thanks, *Rick