Drop list too execute funtion based on selection

JaykSA

New Member
Joined
Oct 11, 2014
Messages
18
Please help. Im out of date with excel:eek:

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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

ParamRay

Well-known Member
Joined
Aug 6, 2014
Messages
1,195
.
.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,906
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top