30 Sep 20, 08:37 PM
|
#5
|
|
30 Sep 20, 08:37 PM
diby5
Imagineer
|
Imagineer
|
Alternatively there may be too many parentheses
=IF(A1*B1<100,100,A1*B1)
or
=MAX(100,A1*B1)
David
__________________
1997 Orange Lake Country Club, 1999 CBR, 2000 Grosvenor/Sandals Royal Bahamian, 2002/3 Wyndham Palace, 2004 ASMo, 2007 POFQ, 2009 CSR, 2010 BC (Disney Wedding), 2011 BWI, 2012 BC, 2013 Poly, January 2015 OKW, November 2015 BC/HoJo Anaheim/Casablanca NYC, 2016 Palm Pavilion Clearwater/AKL, 2019 POR, 2022/3 BC, 2024 YC
Edited at 08:39 PM.
|
|