| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF function....testing against values in multiple cells
Is there a way of writing an IF function to test the values in 3 cells and
return a message depending on which cell has the highest value? For example if A1 = 1000, B1 = 1500, C1 = 1750. If A1 is has the largest value then I would like a return of "Charlie is leading", if B1 is higher then return "Scott is leading" and if C1 is highest then return "Jason is leading" .....is it possible to write this function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to count unique values? | Excel Worksheet Functions | |||
| Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
| Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
| Toggle multiple values in single cell | Excel Worksheet Functions | |||
Threaded Mode
