| 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 | |||
Linear Mode
