Question on IF Function?

[lewehabtamu]

<d3<=700,000 then="" f3="D3*8%+40
<d3<=700,000 then="" f3="D3*8%+40

<d3<=700,000 then=" "=""></d3<=700,000></d3<=700,000>How do I set these parameters?

If D3>700,000 then F3=D3*10%+50
If 400,000<D3<=700,000 then F3=D3*8%+40
If D3<=400,000 then F3=D3*6%+30

 

[alansidman]

In F3 the following formula

=if(D3>700000,(D3*.1)+50,if(D2<=400000,(D3*.06)+30,"Put something here if both statements are False"))