Posted to microsoft.public.excel.newusers

Dave in Ampthill[_2_] Dave in Ampthill[_2_] is offline

external usenet poster

Posts: 10

Multiple IF statement

I am formatting cell D47 and wish the following IF conditions:-

D47 to read 2.00 unless D63175 but<3800 then to read 2.50, if D6 3800
but<4500 then read 3.00, if D64500 then read 3.5

How should this be written in the cell.

Many thanks in advance for your help.

Dave

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
Multiple If statement	John Gregory	Excel Discussion (Misc queries)	8	October 10th 08 05:57 PM
Multiple if Statement?	jeffmp21	Excel Discussion (Misc queries)	6	June 5th 08 07:49 PM
Multiple IF statement	Kristen PS	Excel Worksheet Functions	5	May 13th 08 10:05 PM
Multiple IF Statement	John	Excel Worksheet Functions	4	June 9th 07 02:33 PM
Multiple If Statement	TamIam	Excel Worksheet Functions	8	October 18th 06 08:55 PM

All times are GMT +1. The time now is 01:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us