Solution for 3 conditions (IF)

[stungy]

Hiya folks,

I'm having problem making a formula work. I would appreciate some advise.

=IF(D16="lunch",J15,IF(D16="45",J16),IF(D16="15",J17)))

I'm having too many arguments tho and i won't let go on.

Any suggestions?

[Pichingualas]

Try this:

=IF(D16="lunch",J15,IF(D16="45",J16,IF(D16="15",J17)))

I think it might work. I hope it helps.