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 ?

Please Login or Register  to view this content.

[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?

[RCG]

Thank you trucker, I'm trying although I'm in dire need to sleep where I am

I'll explain the principle behind it

if someone is 3 times tardy he'll be considered 1 day abscent.

so for every 3 Tardy I have 1 Day abscent

if someone is 4 times tardy I'd like to show 1 day abscent until the number reaches 6 then it'll become 2 Day abscent.

That's why I figured I should used >= but i'm not getting it right.

[trucker10]

=if(($u$2>=3),1,if(($u$2>=6),2,if($u$2>=9,3,""))) ? ? Try this one

[RCG]

Nope, but anyways thank you trucker, will get some rest, maybe tomorrow I'll manage to figure it out

[cimmind]

Tried and tested.
This formula worked.

=IF(($A1>=9),3,IF(($A1>=6),2,IF($A1>=3,1,0)))


Whatever IF command you give first, gets precedence.
Changes from earlier formula:
- If Cell value less than 3, get filled as 0
- Removal of the second $ sign means you can drag down and apply the formula over a column of data.

[RCG]

Tried and tested.
This formula worked.

=IF(($A1>=9),3,IF(($A1>=6),2,IF($A1>=3,1,0)))


Whatever IF command you give first, gets precedence.
Changes from earlier formula:
- If Cell value less than 3, get filled as 0
- Removal of the second $ sign means you can drag down and apply the formula over a column of data.

Cimmind thank you, this works for me.