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!
|