Tuition Costs
 

I want to make it so that cell:
I21 = 83.5 If c21 is Resident
I21=226.5 if Non-Resident
If G21=2009/10 or higher

Also:
I21=75.3 if Resident
199.5 if Non resident
If G21=2008/09 lower
I hope this makes sense.

Tuition Costs
 

Assuming that Column G is a date and not just a year, I suggest you define a
cut-off period.

Try this:

I21 =If(and(C21="Resident",G21={Cut-off}),83.5,If(and(C21="Non-Resident",
G21={Cut-off}),226.5,If(and(C21="Resident",G21<{Cut-off}),75.5,If(and
(C21="Non-Resident",G21<{Cut-off}),199.5))))


Sean NWIC wrote:
I want to make it so that cell:
I21 = 83.5 If c21 is Resident
I21=226.5 if Non-Resident
If G21=2009/10 or higher

Also:
I21=75.3 if Resident
199.5 if Non resident
If G21=2008/09 lower
I hope this makes sense.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200908/1