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.