Forum Discussion
MIN Function
Hello, do you have any recommendations pleas for using the 'MIN' function to replicate the results calculated in Excel as per example below? When I try to use it fpor my expression, I get an error due to MIN function only working with column as a reference:
| B | C | D | E | F | ||||||
| Row | Column | |||||||||
| 3 | C 01.00 | 020 | 010 | 187827795 | ||||||
| 4 | less | |||||||||
| 5 | C 05.01 | 010 | 010 | 1975250 | ||||||
| 6 | less | |||||||||
| 7 | C 01.00 | 440 | 010 | 0 | ||||||
| 8 | plus | |||||||||
| 9 | MINIMUM{ | |||||||||
| 10 | C 01.00 | r530 | c10 | 0 | ||||||
| 11 | less | |||||||||
| 12 | C 01.00 | r740 | c10 | 0 | ||||||
| 13 | less | |||||||||
| 14 | C 05.01 | r010 | c020 | 0 | ||||||
| 15 | less | |||||||||
| 16 | C 01.00 | r720 | c10 | 0 | ||||||
| 17 | plus | |||||||||
| 18 | minimum[ | |||||||||
| 19 | C 01.00 | r750 | c10 | 52131120 | ||||||
| 20 | less | |||||||||
| 21 | C 01.00 | r970 | c10 | 0 | ||||||
| 22 | less | |||||||||
| 23 | C 05.01 | r010 | c030 | 0 | ||||||
| 24 | ,0] | |||||||||
| 25 | ,0} | 185,852,545 | =F3-F5-F7+MIN(F10-F12-F14-F16+(MIN(F19-F21-F23,0)),0) |
No Replies