How do I do IF C5=y, then L5*.06 ?

pegdog · Oct 10, 2007

How do I reference cell C5 , which has a Y or N in it, then if it is Y have
it multiply cell L5 by .06?

Gord Dibben · Oct 10, 2007

=IF(C5="Y",L5*0.6,"C5 does not contain a Y")

Gord Dibben MS Excel MVP