View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomGill
 
Posts: n/a
Default 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.