Drop list too execute funtion based on selection

[JaykSA]

Please help. Im out of date with excel

The Drop list is set in a tab named Type

I made a droplist on Ill YES/NO

I want to execute two different fuctions depending on the 2 choices
If YES I want it to take K62*0.5 and dispaly total in K64
If NO I want it to make K62 give the same total too K64

 

[ParamRay]

.
.

Enter this formula in cell K64:

=IF(I11="YES",K62/2,IF(I11="NO",K62,NA()))

The NA() function is optional. I added it in case something else ends up in cell I11.

 

[JaykSA]

Thank you... so much!