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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I do IF C5=y, then L5*.06 ? (https://www.excelbanter.com/excel-worksheet-functions/161531-how-do-i-do-if-c5%3Dy-then-l5%2A-06-a.html)

pegdog

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

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

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

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

Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 20:19:00 -0700, pegdog
wrote:

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?

All times are GMT +1. The time now is 01:41 PM.