Prev: what is a macro?
Next: Stacked chart
From: Cat on 19 Feb 2010 12:20 I have a couple questions. I am creating a spreadsheet to do commissions. First: If A3 is less than $1 I want 0, but if over $1 to calculate at 5% of A2 Second: Then I need if A3 is less than 5% of A2 I need a 4% calculation of A2.
From: Daryl S on 19 Feb 2010 13:00 Cat  Here is what you asked for: A3: =IF(A1<1,0,0.05*A2) A4: =IF(A3<0.05*A2,0.04*A2,0)  Daryl S "Cat" wrote: > I have a couple questions. > > I am creating a spreadsheet to do commissions. > > First: If A3 is less than $1 I want 0, but if over $1 to calculate at 5% of > A2 > Second: Then I need if A3 is less than 5% of A2 I need a 4% calculation of > A2. >

Pages: 1 Prev: what is a macro? Next: Stacked chart 