Multipl IF between 2 values (But 3 differnet values)

**pmw19800** · 02-15-2019, 04:10 AM

Hello

Multiple If

E38 = 400

IN E39 Formula if its between 0-120 display 0, above 120 but below 400 = 1 above 520 but below 800 = 2

so if E38 = 400 >>> E39 = 1
so if E38 = 560 >>> e39 = 2

Paul

**Pepe Le Mokko** · 02-15-2019, 04:14 AM

And above 800 and between 400 and 520?

**pmw19800** · 02-15-2019, 04:18 AM

yes, thats correct,

its working out how many pallets i need.... 40 per box anything above 120 requires a pallet

**Pepe Le Mokko** · 02-15-2019, 04:35 AM

So a pallet takes from 120 to 400 something? And you want to know the number of pallets and remaining boxes?
Could you give a couple of examples please?

**pmw19800** · 02-15-2019, 04:43 AM

120 to 400 is correct
remaining boxes isnt important

**pmw19800** · 02-15-2019, 05:02 AM

please see attached,, examples in yellow

**FlameRetired** · 02-15-2019, 01:10 PM

Please try

Formula:

Please Login or Register  to view this content.

Multipl IF between 2 values (But 3 differnet values)

LinkBack

Thread Tools

Rate This Thread

Display

Multipl IF between 2 values (But 3 differnet values)

Re: Multipl IF between 2 values (But 3 differnet values)

Re: Multipl IF between 2 values (But 3 differnet values)

Re: Multipl IF between 2 values (But 3 differnet values)

Re: Multipl IF between 2 values (But 3 differnet values)

Re: Multipl IF between 2 values (But 3 differnet values)

Re: Multipl IF between 2 values (But 3 differnet values)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Code replace old values to new values depends upon column values

[SOLVED] VBA code to look up a list of values based on entered values and return all values.

Pulling infomation off of multipl sheets on to TOB

assigning date entries to week values and month values to sum column C-N values C-

search for multipl values - copy result

[SOLVED] Vlookup multipl IF's

[SOLVED] Multipl IF Statements - REVISION

Bookmarks

Bookmarks

Posting Permissions