Help with formula please

[marcidee]

Please can you with what I hope will be a simple formula.
In B27 I have a drop down list that states either:
CONNECT MANAGEMENT FEE (10%) No
CONNECT MANAGEMENT FEE (10%) YES

If the line with 'YES' is selected, I would like 'D27' to show 10% of cell D26

Thank you for your help
Marc

 

[Tetra201]

See if any of the following works for you:

=(RIGHT(B27,3)="YES")*D26*10%
=IF(RIGHT(B27,3)="YES",D26*10%,"")

 

[marcidee]

See if any of the following works for you:

=(RIGHT(B27,3)="YES")*D26*10%
=IF(RIGHT(B27,3)="YES",D26*10%,"")

 

[marcidee]

That's worked, thank you so much for your help

 

[Tetra201]

Glad to have helped.