Conditional Formula help required

I am looking for a single formula for excel 2003 to do the following:
If A1=R then A10=400/0.99, If A2=H then A10=400/0.9 if neither is true then
A10=400.

The formula goes in the cell where the result is to appear, A10 in your case.
=if(A1="R",400/0.99,if(A2="H",400/0.9,400))


"TomGill" wrote:

> I am looking for a single formula for excel 2003 to do the following:
> If A1=R then A10=400/0.99, If A2=H then A10=400/0.9 if neither is true then
> A10=400.

=IF(A1="R",400/0.99,IF(A"="H",400/0.9,400))

and put that in A10

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"TomGill" <TomGill@discussions.microsoft.com> wrote in message
news:0936D013-E896-4DC7-B37B-53F52CD9FDAB@microsoft.com...
> I am looking for a single formula for excel 2003 to do the following:
> If A1=R then A10=400/0.99, If A2=H then A10=400/0.9 if neither is true
then
> A10=400.

> I am looking for a single formula for excel 2003 to do the following:
> If A1=R then A10=400/0.99, If A2=H then A10=400/0.9 if neither is true
> then A10=400.


One way is to put this in A10
=400/IF(A1="R",0.99,IF(A1="H",0.9,1))