30 Sep 20, 08:35 PM
|
#4
|
|
30 Sep 20, 08:35 PM
diby5
Imagineer
|
Imagineer
|
I don't think there are quite enough parentheses in BevS97's answer, try this
=IF((A1*B1)<100,100,(A1*B1))
or
=MAX(100,(A1*B1))
which shows the larger value of 100 or A1 x AB
HTH
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
|
|