More IF help needed

M

Michell Major

=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?
 
D

David Biddulph

The formula works OK for me. Are you sure that you haven't mistyped
something?
 
Top