Different Types of Formulae in the same cell

[wayneeustace]

Hi There

I'm having trouble trying to incorporate different formula types in the same cell. Does anyone have any suggestions ?

My current data is:
Cell A1 = 15
A2 = 0.75
A3 = (either "yes" or "no")

In cell A4, I need to:
=A1/A2 (to return a % value); as well as
If A3 = blank or no, then no change; but If A3 = yes, then add 5%

Any assistance would be greatly appreciated

Thanks

 

[arthurbr]

Perhaps =(A1/A2)*(1+(A3="yes")*0.05)

 

[wayneeustace]

Thank you, Arthur - lifesaver

 

[arthurbr]

You're welcome

 

[wayneeustace]

Actually, if I may - another problem has arisen today. How could I get the final cell to add a standard value of 5 to the total, if the previous cell = "yes".

EG:

If A3 = blank or no, then no change; but If A3 = yes, then add 5

A sample would be if the A4 cell finishes at 2.7% and A3 = "yes", then the A4 total would auto-calculate to = 7.7%

Sorry for hassle
​

 

[Peter_SSs]

Try this modification
=A1/A2+(A3="yes")*0.05