Hi!

=IF(G9100,1,IF(G9200,2,IF(G9300,3,)))

If all you needed to check were the 3 conditions in your sample then you
simply need to reverse the logic:

=IF(G9300,3,IF(G9200,2,IF(G9100,1,"not defined")))

Since you have 10 conditions you want to test for, using IF won't work.

What do you want to happen if G9 < 100?

What do you want to happen if G9 = 100, 200, 300 etc.?

Biff

"Trisha V via OfficeKB.com" wrote in message
...

Im working on a formula that looks somewhat like this:

=IF(G9100,1,IF(G9200,2,IF(G9300,3,)))

but it isnt working...what I need is something that says...IF (G9) IS
GREATER
THAN 100 IT WILL EQUAL 1 AND IF GREATER THAN 200, IT WILL EQUAL 2 AND
GREATER
THAN 300, ETC ETC ETC...TILL I GET TO 1000 AND 10.

WHAT AM I DOING WRONG? CAN SOMEONE PLEASE HELP ME?