Thread: Multiple If and Or Statements

I know this can be done and i've got part of it figured out, but keep getting errors. Any help would be appreciated.

I've got a flow chart that goes pretty simple.

If income <75k and networth more then 1 Mill, service fee $4500. If less then 1 Million, $4000
If income >75k but <=100k Service fee .01*networth
If income >100k and Networth <500,000, Service fee $6k
If income >100k and Networth >=500,000 but <=1,000,000, then $8000 service fee.
If income >100k and Networth >1,000,000, then NW*1.5 is service fee.

So Far this is what i've got working. =IF(AND(C2<=75000,D2<=1000000),4000,4500)

When I add in the rest I start getting errors. I know it's possible, just haven't figured out where to put the parentheses and statements.

Thanks

You are correct. After I adjusted the rate to be .015, that worked correctly. Thanks very much.