IF function problem,
Hi,
Am Fri, 13 Sep 2019 14:23:26 +0100 schrieb annae:
I'm trying to calculate a maximum amount of value. That is, if a value
is higher than 50000, it needs to display 50000. If not, display current
value.
A1=35678
B1 should display 35678 (that is, equal to A1)
A1=67980
B1 should display 50000
try:
=MIN(A1,50000)
Regards
Claus B.
--
Windows10
Office 2016
|