View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pegdog pegdog is offline
external usenet poster
 
Posts: 4
Default 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")