Doubling an amount of select yes

[johnrobgray]

Hi all
The help so far has been great

I’ve got another quick enquiry

I want to get my sales sheet to do a calculation based on whether the option Yes is chosen from a drop down menu

For example

If I enter the amount of £1200 into a cell and then in the tracker the option Yes is chosen from a drop down menu, I want the sum of £1200 to double to £2400, but only if the drop down box says yes

Any ideas how I can achieve this?

Thanks

 

[johnrobgray]

Anyone know?

 

[Special-K99]

The DropDown box is linked to a cell isn't it, ie a cell returns the value "Yes" or something else.
Assume this is A1 and the result is in B1 (adjust the formula as necessary)


in B1
=1200+(A1="Yes")*2

 

[johnrobgray]

Yeah that’s right
It’s a drop down box in a cell

I tried that formula and it didn’t multiple it it just added 2 making 1252

My formula reads

=C10+(H10=“Yes”)*2

 

[FormR]

Hi, here is another option:

=IF(H10="Yes",C10*2,C10)

Anyone know?

Note, you should really be waiting a little longer before bumping your posts

 

[Special-K99]

Sorry that should have been

=C10+(H10=“Yes”)*C10

 

[johnrobgray]

Sorry! I’ll remember that

 

[johnrobgray]

That worked a treat
Thank you so much

The last thing I think I need is to put the figure of C10 in a separate cell if yes is selected so I can track the amount of doubled values if that makes sense

So instead of that formula doubling I’m looking to put in another Cell the amount original in C10 if Yes was selected

So in this instance Yes was selected so I’m looking to generate the amount of £1200 in another cell

Thanks

 

[Special-K99]

in the other cell whatever one that is

=IF(H10="Yes",C10,0)

 

[johnrobgray]

Brilliant

That worked a treat thanks so much

I hate to keep bombarding you but one other thing

Can I count how many times something is selected in a drop down. I don’t really want them filtered just the amount of times a drop is used

So I have a drop down box that has 5 options in like phone, tablet etc

I just wanted to count how many times a drop down is used rather than specifically the item selected

It’s to do a conversation rate