Thread: More IF help needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michell Major Michell Major is offline
external usenet poster
  
Posts: 34
Default More IF help needed
=IF(K32="",0,IF(K32="Hackney",25,IF(K32="Lewisham" ,30,26)))+(T32="P")*10

I now need to add one more argument: Returned items attract a £25 charge on
top of the appropriate preceedingcharge. I.e. ..... +(R32="R")*25. However
when I do this a VALUE msg appears. Any ideas?
Reply With QuoteReply With Quote