if the value of a cell =

[RCG]

Hi,

I'm trying to have a cell return a value if the value of another cell = a certain number

this is what I'm trying to do

If Cell A2=3 then the value of Cell A3=1
If A2=6 then A3=2
If A2=9 then A3=3

What's the way to work this? Thank you for the help

[trucker10]

What's the way to work this? Thank you for the help

This way ?

=IF($A$2=3;1;IF($A$2=6;2;IF($A$2=9;3;"")))

[RCG]

No trucker it's not working for me this way, I'm still trying, I hope you'll figure what was wrong with your code. Thanks for helping

[trucker10]

I hope you'll figure what was wrong with your code.

The code is in Dutch ; > ,

=IF($A$2=3,1,IF($A$2=6,2,IF($A$2=9,3,""))) ?

[RCG]

Trucker thank you very much, this works now however led me to another issue to resolve which I realized when this worked, I guess it's getting more complicated now. :D

when 3 = 1
When 6 = 2
When 9 = 2

what happens when it's 4? it's back to zero instead of staying on 1, I'm going to try with greater or equal. Should this work?

[trucker10]

You can do everything, if you try!

[RCG]

Trucker thank you very much, this works now however led me to another issue to resolve which I realized when this worked, I guess it's getting more complicated now. :D

when 3 = 1
When 6 = 2
When 9 = 2

what happens when it's 4? it's back to zero instead of staying on 1, I'm going to try with greater or equal. Should this work?

Tried this, not helping, my result stays 1

=IF($U$2>=3,1,IF($U$2>=6,2,IF($U$2>=9,3,"")))

Is this the way for Greater or equal?