Forum Discussion
formula for If number is greater than.
Currently I have the following formula in a cell: =B6+B7. This gives me the value of the 2 cells, now I'm trying to make it that if the cell is greater than 225000 that it will only have a value of 225000.
=MIN(225000;B6+B7)- Detlef_Lewin, when i type this in it tells me it doesn't work. =MIN(225000;G5+G6)
