Thread: Function IF statement
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Function IF statement
On Fri, 01 Feb 2008 23:34:50 -0500, Ron Rosenfeld
wrote:

Should be:

=C2*D2+D2*0.5*MAX(0,C2-40)

Or a bit shorter:


=D2*(C2+0.5*MAX(0,C2-40))


--ron
Reply With QuoteReply With Quote