Formula to make cell conditional upon the content of another cell

[nalamarmite1]

Hi,

I would like to make a cell conditional upon the content of another cell.

E.g.

if A1 is >30 then A2 should be 'Must'
if A1 is >20 but less than 30 then A2 should be 'Should'

Thank you in advance!

[Kevin#]

paste this into A2
=IF(A1>30,"Must",IF(A1>20,"Should",""))

[nalamarmite1]

Thank you!

[Kevin#]

please mark the thread as solved
thanks

[nalamarmite1]

Hi I just tried to insert this:

=IF(AC4>30,"Must",IF(AC420:29,"Should",)IF(AC410:19”Could”,)IFAC4<9, “Will not”,)IF(AC4=”Legal”, “Legal”,""))))

As I now want to show these rules:

30 – 45 = Must
20 – 29 = Should
10 – 19 = Could
0 – 9 = Will not
Legal = Must

I obviously got something wrong because Excel didn't like it!

Can anyone help and get this right for me?

Thank you.

[Kevin#]

Paste this into A2 and put values into A1
=IF(A1="Legal","Must",IF(A1>45,"",IF(A1>29,"Must",IF(A1>19,"Should",IF(A1>9,"Could",IF(A1>=0,"Will Not"))))))

[nalamarmite1]

Thank you I will mark this solved