Try it this way:
=if(c3<=70%,1,if(c3<=83%,2,if(c3<=89%,3,"Outside range")))

You didn't say what happens when c3 is exactly 70%, so I assumed you wanted
1.

Regards,
Fred.

"Pullge" wrote in message
...
I am trying to create a formula that will assign a value such as 1, 2 or 3
based on the cell percentage value.

If the cell is < 70.00% then it's value will be a 1
If the cell is between 70.01% and 83.00% then it's value will be 2
If the cell is between 83.01% and 89.00% then the value will be 3

The cell currently will pull data from another source and I have a new
sheet
that needs to be able to look at the current percentage and then take the
value of 1 or 2 or 3 and then multiply it by a set variable.

So if Cell C3 has a current value of 73.00% it would need to be assigned
the
value of 1. Then the formula would need to take the value 1 and muliply
it
by 2 to give me my final value of 2

I have tried many variables, but not able to get the syntax or formula
correct. Any help is most appreciated.