Posted to microsoft.public.excel.misc

Michell Major Michell Major is offline

external usenet poster

Posts: 34

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sports Comp Ladder tabulating help needed	shaunl	Excel Worksheet Functions	12	January 29th 14 01:25 PM
fomula needed to find the "new" time, for example if	[email protected]	Excel Discussion (Misc queries)	7	June 27th 06 12:24 AM
IF / Else Format help needed	Paul B.	Excel Worksheet Functions	5	January 5th 06 06:37 PM
solver related some financial knowledge may be needed	Richard Payman	Excel Discussion (Misc queries)	4	September 8th 05 02:37 PM
Custom percent format needed	Will Fleenor	Excel Worksheet Functions	1	June 29th 05 02:57 AM

All times are GMT +1. The time now is 07:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us