Tuition Costs

[Sean NWIC]

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.

 

[pogiman via OfficeKB.com]

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