| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
