30 Sep 20, 07:50 PM
|
#2
|
| |
30 Sep 20, 07:50 PM
BevS97
VIP Dibber
|
|
VIP Dibber
Join Date: Mar 02
|
=if(a1 * b1) < 100, 100, a1 * b1)
I’m not actually at my pc but that’s more or less how you would do it.
If a x b is less than 100 then the answer is 100 else the answer is a x b.
Edited at 07:53 PM.
|
|