| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
| fomula needed to find the "new" time, for example if | Excel Discussion (Misc queries) | |||
| IF / Else Format help needed | Excel Worksheet Functions | |||
| solver related some financial knowledge may be needed | Excel Discussion (Misc queries) | |||
| Custom percent format needed | Excel Worksheet Functions | |||
Linear Mode
