Resend my activation email : Register : Log in 
BCF: Bike Chat Forums


exel formulas

Reply to topic
Bike Chat Forums Index -> Dear Auntie BCF...
View previous topic : View next topic  
Author Message

gavcarter
Could Be A Chat Bot



Joined: 28 Mar 2009
Karma :

PostPosted: 17:36 - 08 Apr 2014    Post subject: exel formulas Reply with quote

Is any one really good with exel formulas?

I need help with some complicated if formulas.

I have 4 columns, height, width, length and weight.

I need a formula that will pop them into bands.

For example I need to check if the L,W,H and weight are less than royal mail max for std parcels, if they are assign a value or text relating to RM. If they are bigger assign a value or text relating to courier ( there will be a few bands for courier so this will end up a big formula....

thanks

Gavin
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

dodsi
Dirty Carny



Joined: 06 Aug 2004
Karma :

PostPosted: 20:02 - 08 Apr 2014    Post subject: Reply with quote

It's just IF AND statements... Pretty straight forward.

If a1 > d1 And a2 > d2 etc etc
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

gavcarter
Could Be A Chat Bot



Joined: 28 Mar 2009
Karma :

PostPosted: 22:09 - 08 Apr 2014    Post subject: Reply with quote

dodsi wrote:
It's just IF AND statements... Pretty straight forward.

If a1 > d1 And a2 > d2 etc etc


it is until theres about 50 ifs and ands.....

I can mange a couple but this is baffling me
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

gavcarter
Could Be A Chat Bot



Joined: 28 Mar 2009
Karma :

PostPosted: 22:49 - 08 Apr 2014    Post subject: Reply with quote

sorted by a bcf hero Thumbs Up Thumbs Up
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

lihp
World Chat Champion



Joined: 22 Sep 2010
Karma :

PostPosted: 22:51 - 08 Apr 2014    Post subject: Reply with quote

dodsi wrote:
It's just IF AND statements... Pretty straight forward.

If a1 > d1 And a2 > d2 etc etc


Not that straight forward as that won't work Wink Need multiple nested IF with a nested AND

=IF(AND(######,####,###),"","")
____________________
covent.gardens: lihp is my most favourite member ever
 Back to top
View user's profile Send private message You must be logged in to rate posts

el_oso
World Chat Champion



Joined: 17 May 2008
Karma :

PostPosted: 21:41 - 11 Apr 2014    Post subject: Reply with quote

you may have better luck creating pivot tables and using the grouping tool or if you have 2013 then you can group rows in a table.
____________________
Duke 390
Previous: '05 XR125L | '96 XJ600S Diversion |'05 Suzuki GSXR1000 | '05 Honda CBR125-R | '97 YZF 600R Thundercat | '11 Honda CBR250
Car: Jeep Wrangler 4.0L
 Back to top
View user's profile Send private message You must be logged in to rate posts
Old Thread Alert!

The last post was made 12 years, 222 days ago. Instead of replying here, would creating a new thread be more useful?
  Display posts from previous:   
This page may contain affiliate links, which means we may earn a small commission if a visitor clicks through and makes a purchase. By clicking on an affiliate link, you accept that third-party cookies will be set.

Post new topic   Reply to topic    Bike Chat Forums Index -> Dear Auntie BCF... All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Read the Terms of Use! - Powered by phpBB © phpBB Group
 

Debug Mode: ON - Server: biskey (www) - Page Generation Time: 0.04 Sec - Server Load: 0.56 - MySQL Queries: 14 - Page Size: 47.12 Kb