Help with Nested IF statement

[Dinonz]

I'm trying to compile a redundancy spreadsheet and have three totals I'm trying to combine into a formula:

• Total A is a redundancy total (which has been calculated based on daily rate of pay x length of service x no of weeks redundancy)
• Total B is a salary total (which has been calculated based on the salary that would otherwise be paid between the redundancy date and the date the individual was due to retire if redundancy was not taken)
• Total C is $50,000

What I am trying to get the formula to do is:

If A is less than B and B is less than C then display A, or
If B is less than A and B is less than C then display B, otherwise
Display C

or put another way, display $50,000 or either Total A or B, whichever is the lesser of the three totals.

Any help would be greatly appreciated.

 

[VoG]

Try

=MIN(A1,B1,C1)

 

[Dinonz]

Fantastic VoG, problem solved.

Thanks for the quick response!