Need Function to yes or no drop down box

**Dawna Williamson** · 08-28-2014, 10:07 PM

If N14 is yes, I need cell E43 to insert cell C43 amount, but if N14 is NO then I need cell C43 and D43 to be added together into cell E43. Can someone help me with this.

**alansidman** · 08-28-2014, 10:10 PM

In E43 type: IF(N14 = "Yes", C43,C43 + D43)

**Dawna Williamson** · 08-28-2014, 10:20 PM

Thanks, you would think that would work but it's not. It doesn't give me errors but nothing happens.

**kvsrinivasamurthy** · 08-29-2014, 08:42 AM

try this in E43 type:
IF(N14 = "Yes", value(C43),Value(C43) + value(D43))

**Tony Valko** · 08-29-2014, 08:53 AM

Originally Posted by kvsrinivasamurthy

try this in E43 type:
IF(N14 = "Yes", value(C43),Value(C43) + value(D43))

If the entries are really TEXT numbers then the math operation of adding them together should convert them to numeric numbers.

=IF(N14="Yes",C43+0,C43+D43)

However, if the entries are TEXT numbers then they should be "fixed" at the source.

**Dawna Williamson** · 08-31-2014, 01:40 PM

Thank you, I'm going to give this a try. Wish me luck

Need Function to yes or no drop down box

LinkBack

Thread Tools

Rate This Thread

Display

Need Function to yes or no drop down box

Re: Need Function to yes or no drop down box

Re: Need Function to yes or no drop down box

Re: Need Function to yes or no drop down box

Re: Need Function to yes or no drop down box

Re: Need Function to yes or no drop down box

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Drop Down function

Excel 2008 : Drop down function

IF function and drop-down lists

[SOLVED] help with multiple function from drop down box

Is a Drop Down box the best function to use?

Bookmarks

Bookmarks

Posting Permissions