Conditional Formula help required
=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" wrote in message
...
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.
|