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
Moderator

 
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 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
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 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

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 10:42 AM.


Powered by vBulletin - Copyright © 2000 - 2020, Jelsoft Enterprises Ltd.
Latest News
Posted in Walt Disney World
On 27th October 3:18pm
Walt Disney World has announced that their entrance gateways to Walt Disney World are about... Read More »
Posted in Disneyland News
On 21st October 8:51am
Disneyland California is the only major Disney theme park to not reopen after all the... Read More »
Posted in Disney Shopping
On 18th October 9:02am
Disney has reduced the price of its large soft toys by up to 50%. Bargains... Read More »

theDIBB Menu


Exchange Rates
US Dollar Rates
ASDA  $1.2775
CaxtonFX  $1.2651
Covent Garden FX  $1.2777
FAIRFX  $1.2790
John Lewis  $1.2781
M&S  $1.2605
Post Office  $1.2578
Sainsburys  $1.2747
TESCO  $1.2778
Travelex  $1.2720
Updated: 09:30 28/10/2020
Euro Rates
ASDA  €1.0855
CaxtonFX  €1.0766
Covent Garden FX  €1.0890
FAIRFX  €1.0815
John Lewis  €1.0858
M&S  €1.0704
Post Office  €1.0679
Sainsburys  €1.0833
TESCO  €1.0855
Travelex  €1.0802
Updated: 09:30 28/10/2020

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