IF function problem,
 

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

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

IF function problem,
 

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




--
annae
Public Sub Answeer1()
' Prepared By Nasser Saadi (www.Nasser-Saadi.org)
' Date: 2019-Sep-19
' Address: Iraq (Or Arbil Or Irbil)
' ------------------------
Dim A1, B1 As Integer:
A1 = 23445
B1 = IIf(A1 = 50000, 50000, A1)
MsgBox " A1= " & A1 & " B1= " & B1 ' we can use one of display (Msgbox or Print)
Print " A1= " & A1 & " B1= " & B1 ' we can use one of display (Msgbox or Print)

End Sub

IF function problem,
 

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




--
annae

Public Sub Answeer1()
' Prepared By Nasser Saadi (www.Nasser-Saadi.org)
' Date: 2019-Sep-19
' Address: Iraq (Or Arbil Or Irbil)
' ------------------------
Dim A1, B1 As Integer:
A1 = 23445
B1 = IIf(A1 = 50000, 50000, A1)
' we can use one of display (Msgbox or Print)
MsgBox " A1= " & A1 & " B1= " & B1
Debug.Print " A1= " & A1 & " B1= " & B1


End Sub

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