Thread: What is the correct formula for IF C5 = Y, then L5 *.06?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default 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!


Reply With QuoteReply With Quote