multiple formula reliant on one truth

[Rosemary_Coombes]

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel I am trying to create a formula which is based on one cell having the value "complete". If that cell is "complete" then depending on the number value a certain level of commission is based:

the formula i use to calculate the commission is
IF(A2

 

[Carl Witthoft]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

I am trying to create a formula which is based on one cell having the value
"complete". If that cell is "complete" then depending on
the number value a certain level of commission is based: <br><br>the formula
i use to calculate the commission is <br>
IF(A2<G2,0,IF(A2=G2,H2,IF(A2<G3,H2,IF(A2=G3,H3)))) <br><br>So if A2 is less
than $1000, 0, if equals $1000, $50, if less than $2000, $100, etc
<br><br>this works fine but when I try to bring in the constant of
&quot;complete&quot;. I have tried various things but all without result. Any
help is much appreciated.

Contents of cell H1 = "complete" (without thequote marks)

IF(A2 = H1,"A2 is complete", {Fill_in_Your_other_Comparisons_here})

Now, a single cell cannot both contain a number and a string (word).
If my suggestion isn't what you want, please post the actual cell values
and formulas you're using.

And please do not use html in your posts.