Thread: Formula problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Janet Janet is offline
external usenet poster
 
Posts: 49
Default Formula problem

Here's the set up:
A1 has 300,000
A2 has 1,000,000
A3 has 1,200,000

I want an if statement that if one of the following is above 1,000,000 then
to multiply by 33% + 400,000. I want a statement that I want anything over
1,000,000 be multiplied by 33% + 400,000. Help!