|
Guest Services Site Questions, a tech query or just want to test something. |
|
Thread Tools | Search this Thread | Display Modes |
30 Sep 20, 07:47 PM |
#1
|
|
VIP Dibber
|
Any excel experts
Hi everyone
Anyone know a formula to use in excel for this. Column a will be 1 Column b will be 1.00 Column c will be the sum of a x b However if the figure is column A is below 100 then it needs to show 100 as a minimum Hope this makes sense! Thank you
__________________
WDW Visited in 1992, 1995, 1997, 1998, 2004, 2005, 2007, 2008, 2010, 2011, 2013 |
|
|
30 Sep 20, 07:50 PM |
#2
|
|
VIP Dibber
|
=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. |
|
|
30 Sep 20, 08:03 PM |
#3
|
|
Thread Starter
VIP Dibber
|
Thanks I can’t get it to work but will try and google!
__________________
WDW Visited in 1992, 1995, 1997, 1998, 2004, 2005, 2007, 2008, 2010, 2011, 2013 |
|
|
30 Sep 20, 08:35 PM |
#4
|
|
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 |
|
|
30 Sep 20, 08:37 PM |
#5
|
|
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. |
|
|
30 Sep 20, 10:08 PM |
#6
|
|
Thread Starter
VIP Dibber
|
Thank you both
__________________
WDW Visited in 1992, 1995, 1997, 1998, 2004, 2005, 2007, 2008, 2010, 2011, 2013 |
|
|
|
DIBB Savings |
AttractionTickets.com
Get £10 off each Disney Ticket with the code ATDIBB10 Get up to £50 off per room at Disney or Universal with the code DIBBHOTELS |
theDIBB Blog |
Guests can book their 2025 Hotel and Ticket package early to enjoy Free Dining &... Read More »
The iconic 1900 Park Fare restaurant is opening its doors once again at Disney’s Grand... Read More »
One of the the five worlds found in Epic Universe, How to Train Your Dragon... Read More »
|
theDIBB Menu |
Exchange Rates |
US Dollar Rates
Euro Rates |
DIBB Premium Membership |
Did you know you can help support theDIBB with Premium Membership? Check out this link for more information and benefits, such as... "No adverts on theDIBB Forums" Upgrade Now |