Please can someone help with an IF formula

[marcidee]

in C27 I have a drop down box that says
CONNECT MANAGEMENT FEE (10%) Yes
CONNECT MANAGEMENT FEE (10%) NO

I have this formula which works fine in Cell D27

=IF(RIGHT(C27,3)="YES",D28*10%,"")

(so if No D27 is empty, if Yes Calculates 10% of D28)

Now in D28 I would like:
If C27 = YES it calculates (D26*0.111109)+D26
If C27 = No (or C27 is empty) D28 is the same as D26
Thank you for your help
Marc

 

[Sergius]

Hello! If I understand correctly.

Book1
	C	D
26		10
27	Yes	11,11109
28		11,11109
Sheet1

Cell Formulas
Range	Formula
D27	D27	=IF(RIGHT(C27,3)="YES",(D26*0.111109)+D26,"")
D28	D28	=IF(RIGHT(C27,3)="YES",(D26*0.111109)+D26,IF(OR(RIGHT(C27,3)="YES",C27=""),D26,""))

 

[marcidee]

Thank you for this, but it doesn't quite work. Formula in D27 was previously fine (if YES then 10% of D28, if No then leave blank) - so I haven't changed that.

The new formula for D28 leaves D28 blank if D27 is No. What I need is, if 'NO' D28 is the same as D26. If YES then =(D26*0.111109)+D26

Can you tweak please?
Thanks Marc

 

[Sergius]

So?

Book1
	C	D
26		10
27	no
28		10
Sheet1

Cell Formulas
Range	Formula
D27	D27	=IF(RIGHT(C27,3)="YES",(D26*0.111109)+D26,"")
D28	D28	=IF(D27<>"",(D26*0.111109)+D26,D26)

 

[marcidee]

Thank you for the update. Now if D27 = NO D28 is the same as D26 (perfect)
But if D27 - No i get a #ref!

I think I need a combination of your first and second answers.

So what I need is:

I am not touching the formula in D27 as that works fine (=IF(RIGHT(C27,3)="YES",D28*10%,"")

The formula (D26*0.111109)+D26 is for cell D28

So if D27 = Yes then in D28 then in D28 =(D26*0.111109)+D26
If D27 is No then D28 is the same as D26

Thanks again for helping me
Marc

 

[marcidee]

Hi Sergius

I have managed to get this working by combining your 2 formulas

=IF(RIGHT(C27,3)="YES",(D26*0.111109)+D26,IF(D27<>"",(D26*0.111109)+D26,D26))

Thank you so much for your help

Marc

 

[C with no eyes]

=IF(RIGHT(C27,3)="yes",D26*1.111109,D26)

 

[Sergius]

marcidee, glad I could help you. Welcome to the form.

 

[Peter_SSs]

I have managed to get this working by combining your 2 formulas

=IF(RIGHT(C27,3)="YES",(D26*0.111109)+D26,IF(D27<>"",(D26*0.111109)+D26,D26))

That could be written more succinctly as

=D26+D26*0.111109*OR(D27<>"",RIGHT(C27,3)="YES")

Or if C27 is actually just Yes or No as indicated by some of your earlier formulas then

=D26+D26*0.111109*OR(D27<>"",C27="YES")

 

[marcidee]

That could be written more succinctly as

=D26+D26*0.111109*OR(D27<>"",RIGHT(C27,3)="YES")

Or if C27 is actually just Yes or No as indicated by some of your earlier formulas then

=D26+D26*0.111109*OR(D27<>"",C27="YES")

Thank you for the above - neither of the 2 above work if C27 is 'Yes' (works fine with 'No', ie if No then D28 is the same as D26) - however if C27 is Yes, then D28 should be D26*0.111109
If C27 is set to yes, your formula gives #ref! in D27 and D28