=IF statement assistance

[Sawdeeka01]

Hi,

I am hoping you could assist me with a formula I need.

K2 has a drop down list with the following options; 12 month nomination or 2 year review.

K36 needs to be able to calculated based on the option selected above. e.g if 12 month nomination is selected then K36 needs to divide K35 by 26, if 2 year review is selected in K2, then K36 needs to divide K35 by 52.

I really hope I haven't confused you too much!

 

[aghaffar82]

Please try this:

=IF(K2="","",IF(K2="12 month nomination",K35/26,K35/52))

 

[Peter_SSs]

Another option to try

=IF(K2="","",K35/(26*LEFT(K2,1)))