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

 

[Special-K99]

Am not sure how to do that apart from using VBA of which I'm not an expert.

 

[johnrobgray]

No bother mate

I’ll post on main room

You’ve been amazing up till now