View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default 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")