IF function problem,
Nasser Saadi wrote:
On Friday, September 13, 2019 at 4:49:08 PM UTC+3, annae wrote:
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
B1 = IIf(A1 = 50000, 50000, A1)
Formula in B1: =if(A150000,50000,A1)
Just one "i" ;)
--
Vie : n.f. maladie mortelle sexuellement transmissible
Benoit chez lui à leraillez.com
|