Odd question, probably easy answer

[dowcraig]

I'm trying to work on something that will allow me to do something if two results equal something...
so

If cell C4>499999 AND Cell C7=1, then multiply contents of cell C5 by .45
If cell C4>499999 and cell C7=2, then multiply contents of cell C5 by .55
If cell C4>499999 and cell C7=3, then multiply contents of cell C5 by .65
If cell C4>499999 and cell C7=4, then multiply contents of cell C5 by .85
If cell C4>499999 and cell C7=5, then multiply contents of cell C5 by 1.00
If cell C4<500000 and cell C7>1, then multiply contents of cell C5 by .70
If cell C4<500000 and cell C7=1, then multiply contents of cell C5 by .50

and i just can't seem to get that into a forumla that works.

Thoughts?

Thanks,
Craig

 

[c_m]

These are dollars that will never have a decimal place, I don't think. Still a problem?

so if your dollar value doesn't have a decimal then the value in C7 can either be 499999 or 500000. Right?

 

[dowcraig]

What I'm trying to achieve, haha, is if it's above and including $5,000,000 then put that... if it's below it, then put that..

 

[c_m]

What I'm trying to achieve, haha, is if it's above and including $5,000,000 then put that... if it's below it, then put that..

then your if statement should be something like:
=if(C7>=5000000,some expression for TRUE,some expression for FALSE)

 

[dowcraig]

then your if statement should be something like:
=if(C7>=5000000,some expression for TRUE,some expression for FALSE)

Great! Thanks for your help!!