Home 
Search 
Today's Posts 
#1




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 Last edited by annae : September 13th 19 at 02:33 PM 
#2




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 
#3




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.NasserSaadi.org) ' Date: 2019Sep19 ' 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 
#4




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.NasserSaadi.org) ' Date: 2019Sep19 ' 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 
#5




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 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Sum function problem  New Users to Excel  
Problem with = in function  Excel Worksheet Functions  
Problem with Function  Excel Worksheet Functions  
Mid Function Problem  Excel Discussion (Misc queries)  
PC to MAC VBA function problem  Excel Programming 