Notices
Guest Services Site Questions, a tech query or just want to test something.

Reply
 
Thread Tools Search this Thread Display Modes
Old 30 Sep 20, 07:47 PM  
Link to this Post
#1
Disneymaddaddy
VIP Dibber
 
Disneymaddaddy's Avatar
 
Join Date: Jul 10
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
Disneymaddaddy is offline Boy Mouse Click to view Members Trip Plans Add Member to Ignore List
Old 30 Sep 20, 07:50 PM  
Link to this Post
#2
BevS97
VIP Dibber
 
BevS97's Avatar
 
Join Date: Mar 02

BevS97's Reviews
Hotel Reviews: 7

theDIBB Guidebook
Pages Created: 9
Guidebook Photos: 18
Guidebook Reviews: 7
=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.
BevS97 is online now Girl Mouse Click to view Members Trip Plans Add Member to Ignore List
Old 30 Sep 20, 08:03 PM  
Link to this Post
#3
Disneymaddaddy
Thread Starter
VIP Dibber
 
Disneymaddaddy's Avatar
 
Join Date: Jul 10
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
Disneymaddaddy is offline Boy Mouse Click to view Members Trip Plans Add Member to Ignore List
Old 30 Sep 20, 08:35 PM  
Link to this Post
#4
diby5
Imagineer
 
diby5's Avatar
 
Join Date: May 07
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
diby5 is offline Click to view Members Trip Plans Add Member to Ignore List
Old 30 Sep 20, 08:37 PM  
Link to this Post
#5
diby5
Imagineer
 
diby5's Avatar
 
Join Date: May 07
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.
diby5 is offline Click to view Members Trip Plans Add Member to Ignore List
Old 30 Sep 20, 10:08 PM  
Link to this Post
#6
Disneymaddaddy
Thread Starter
VIP Dibber
 
Disneymaddaddy's Avatar
 
Join Date: Jul 10
Thank you both
__________________


WDW Visited in 1992, 1995, 1997, 1998, 2004, 2005, 2007, 2008, 2010, 2011, 2013
Disneymaddaddy is offline Boy Mouse Click to view Members Trip Plans Add Member to Ignore List
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Forum Jump


All times are GMT +1. The time now is 12:41 PM.


Powered by vBulletin - Copyright © 2000 - 2024, Jelsoft Enterprises Ltd.
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
Disney announced that a new nighttime show, “Disney Dreams That Soar,” will run nightly at... Read More »
Walt Disney World Resort guests can get ready to have a “glowing’’ good time when... Read More »
Aquatica Orlando announce the grand opening of its newest attraction, Tassie’s Underwater Twist, on 15... Read More »


theDIBB Menu


Exchange Rates
US Dollar Rates
ASDA  $1.2347
CaxtonFX  $1.2308
Covent Garden FX  $1.2432
FAIRFX  $1.2350
John Lewis  $1.2380
M&S  $1.2178
Sainsburys  $1.2337
TESCO  $1.2343
Travelex  $1.2353
Updated: 11:30 28/03/2024
Euro Rates
ASDA  €1.1426
CaxtonFX  €1.1403
Covent Garden FX  €1.1509
FAIRFX  €1.1432
John Lewis  €1.1457
M&S  €1.1263
Sainsburys  €1.1419
TESCO  €1.1425
Travelex  €1.1435
Updated: 11:30 28/03/2024

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



X