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

Multiple IF statement
 

Hi Dave

=IF(AND(D63175,D6<=3800),2.5,
IF(AND(D63800,D6<=4500),3.0,
IF(D64500,3.5,2.0)))

I assumed you wanted the upper level included as part of the range in each
case, so I made it <=3800 etc.
Otherwise, values of 3800 and 4500 would be missed altogether.

--
Regards
Roger Govier

"Dave in Ampthill" wrote in
message ...
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

Multiple IF statement
 

Many thanks Roger, you've been a great help.

"Roger Govier" wrote:

Hi Dave

=IF(AND(D63175,D6<=3800),2.5,
IF(AND(D63800,D6<=4500),3.0,
IF(D64500,3.5,2.0)))

I assumed you wanted the upper level included as part of the range in each
case, so I made it <=3800 etc.
Otherwise, values of 3800 and 4500 would be missed altogether.

--
Regards
Roger Govier

"Dave in Ampthill" wrote in
message ...
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

Multiple IF statement
 

Other possibility

=lookup(d6,{0,3175,3800,4500},{2.0,2.5,3.0,3.5})


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39591

Multiple IF statement
 

try
=if(d64500,3.5,if(d63800,3,if(d63175,2.5,2.00)) )
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dave in Ampthill" wrote in
message ...
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