Multiple IF Statements

[sbremner]

Hi guys,

Another problem for you. I am doing some work and requires multiple IF
statements to be used. I know how to write a statement if all cells
have a common factor, for example:

Code:--------------------------------------------------------------------------------
=IF(OR(E11="Error",E15="Error",E23="Error",E29="Error",E44="Error",E48="Error"),"Check
N/a Boxes",(D57/A57))
--------------------------------------------------------------------------------
But how do I write it to display different results.

For example, in the attached file, I basically want the "Risk" box to
display a potential risk factor.
See file for details.

Hope you can help.

Thanks again

Steve

Attachment filename: example1.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=397090

 

[Bob Phillips]

Steve,

Try this and format as percentage

=IF(B4=1,25%,IF(B5=1,50%,IF(B6=1,75%,IF(B7=1,"Rejected"))))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)