ExcelBanter - More IF help needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - More IF help needed (https://www.excelbanter.com/excel-discussion-misc-queries/118577-more-if-help-needed.html)

Michell Major

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?

David Biddulph

More IF help needed

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

"Michell Major" wrote in message
...
=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?

Michell Major

More IF help needed

David, I'll try again. Dan

"David Biddulph" wrote:

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

"Michell Major" wrote in message
...
=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?

All times are GMT +1. The time now is 08:59 PM.