4 different if statements, not working

[Brian]

I have tried the *if between statements but that gives me a value error.

=(IF(A21="P1","1p",A21),(A21="p2","2p",A21),(A21="p3","3p",A21),(A21="p4","4p",A21))

how am I supposed to link these up?

Thanks
Brian

 

[Don Guillett]

You can nest as shown here with an extra ) for each if
=IF(A21="p1","1p",IF(A21="p2","2p",A21))
or you could use LOOKUP

 

[tjtjjtjt]

I have tried the *if between statements but that gives me a value error.

=(IF(A21="P1","1p",A21),(A21="p2","2p",A21),(A21="p3","3p",A21),(A21="p4","4p",A21))

how am I supposed to link these up?

Thanks
Brian

 

[tjtjjtjt]

I tried to Cancel that post and apparently hit the wrong button.

tj

 

[Brian]

Hello and thank you for your response.
I tried to add an extra ) but it is not working. Am I doing something wrong?
I can't use a lookup for this.

=IF(A21="p1","1p",IF(A21="p2","2p",A21,if(a21="p3","3p",if(a21="p4","4p",a21))))

Thanks Brian

 

[Brian]

Cancel that last post (except for the thank you part)
I got it, I missed the A21 in the mix.

Thanks again
brian