| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating costs | Excel Worksheet Functions | |||
| Excel - tuition savings question | Excel Worksheet Functions | |||
| COMPARE CURRENT MORTAGAGE COSTS TO NEW MORTAGAGE COSTS | Excel Discussion (Misc queries) | |||
| COMPARE CURRENT MORTAGAGE COSTS TO NEW MORTAGAGE COSTS | Excel Discussion (Misc queries) | |||
| Estimating costs | Excel Worksheet Functions | |||
Hybrid Mode
