Thread
:
Multiple IF statement
View Single Post
#
5
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett