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
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
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
--Public Sub Answeer1()
annae
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)
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 12:05:09 |
Calls: | 6,645 |
Calls today: | 5 |
Files: | 12,190 |
Messages: | 5,326,716 |