| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the correct formula for IF C5 = Y, then L5 *.06?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the correct formula for IF C5 = Y, then L5 *.06?
=IF(C5="Y",L5*.06,"")
returns nothing if C5 is not Y -- Regards, Peo Sjoblom "pegdog" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the correct formula for IF C5 = Y, then L5 *.06?
On Oct 9, 11:26 pm, pegdog wrote:
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") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the correct formula for IF C5 = Y, then L5 *.06?
Thanks!! It worked!
"pegdog" wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the correct formula for IF C5 = Y, then L5 *.06?
Thanks!, that also helped for the C5 =N part of the problem!
"JW" wrote: On Oct 9, 11:26 pm, pegdog wrote: 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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need the correct formula | Excel Discussion (Misc queries) | |||
| Please Correct the formula | Excel Discussion (Misc queries) | |||
| How do I correct this formula? | Excel Worksheet Functions | |||
| What's the correct formula? | Excel Discussion (Misc queries) | |||
| How I need correct formula, that no t rounding? | Excel Worksheet Functions | |||
Linear Mode
