What is the correct formula for IF C5 = Y, then L5 *.06?

[Guest]

Please help me out on this one, I've tried what seems like every combination
of () and " and everything else I can think of! Thanks!

 

[Peo Sjoblom]

=IF(C5="Y",L5*.06,"")

returns nothing if C5 is not Y

 

[JW]

Please help me out on this one, I've tried what seems like every combination
of () and " and everything else I can think of! Thanks!

=IF(C5="Y",L5 *0.06,"something else")

 

[Guest]

Thanks!! It worked!

 

[Guest]

Thanks!, that also helped for the C5 =N part of the problem!