| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
urgent...convert sum into max
sorry for the urgency but i thought i posted this message yesterday afternoon
and assumed that i could make some headway this am...but it doesn't appear to have posted. Question: is there a way to convert a forumula that looks like this =a1+a2+a3 to Max(a1,a2,a3)? also can i convert =sum(a1:a3) to max(a1:a3). in the first case it has 3 entries, in another instance it might have 4, 5, etc. do i use the subtitute function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Pls, how to convert an addin xlam file to xls worksheet in | Excel Discussion (Misc queries) | |||
| IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
| Urgent Help!!! | Excel Worksheet Functions | |||
| Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Threaded Mode
