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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |