1. ## adding to existing formula

Hi!

i have an existing formula and wanted to add to it but have trouble with "too many arguments"

in cell "F4" you can choose what level of program you started on and in cell "H4" its the start date. so i want to the formula to change your end date in "I4" to coincide with your program level (higher the program, the longer your enrolled on it)

so far i have (which works)
=IF(F4=2,(H4+366),IF(F4=3,(H4+456)))

but i want to add on these rules
IF(F4=4,(H4+546))
IF(F4=5,(H4+546))

any help would really be appreciated!

Thanks  Register To Reply

2. ## Re: adding to existing formula

Hello
I would create a lookup table with your levels and plus values. For example:

Formula:  `Please Login or Register  to view this content.`

That would find the matching Level value and add it to the start date. You can then add or adjust the levels easily rather than having them hard-coded.

DBY  Register To Reply

3. ## Re: adding to existing formula

=IF(F4=2,H4+366,IF(F4=3,H4+456,if(or(f4=4,f4=5),h4+546,""))) might be another way.  Register To Reply