Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Minimum of 6 fields

Status
Not open for further replies.

oville

MIS
Jan 18, 2011
2
US
Hi Trying to find the minimum of 6 credit score fields for each record.(1 record per employee). Looks like this
Emplyee Scr1 Scr2 Scr3 Scr4 Scr5 Scr6
Kip 600 625 645 625 700 725
Kim 725 725 745 750 700 750

Need to create a formula that shows the minimum score out of the 6 for each employee. Kip would show 600 and Kim 700

Thanks in advance
 
Think I found it in another thread
//{@min}:
//minimum([{@trim1},{@trim2},{@trim3}])

//{@max}:
//maximum([{@trim1},{@trim2},{@trim3}])

Thanks anyway
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top