help with formula
 

i am trying to create a formule that will calculate certain rates depending
on zones cubic metres and branch. this is what i need to do:

if cell e8=3 and e4 is equal to or less than 30 = shhet2 g37
how would i write this as an excell formula.
also can a Value be a word say
if b9 equals sydney and e4 is equal to or less than 24 =424=150

help with formula
 

=IF(AND(E8=3,E4<=30),Sheet2!G37,0)

"pezacide" wrote:

i am trying to create a formule that will calculate certain rates depending
on zones cubic metres and branch. this is what i need to do:

if cell e8=3 and e4 is equal to or less than 30 = shhet2 g37
how would i write this as an excell formula.
also can a Value be a word say
if b9 equals sydney and e4 is equal to or less than 24 =424=150

help with formula
 

how would i put multiple formulas of the same vane in the one cell ie
=IF(AND(E8=2,E4<=30),Sheet2!G37,0), =IF(AND(E8=4,E4<=30),Sheet2!G37,0)
etc

"Mike" wrote:

=IF(AND(E8=3,E4<=30),Sheet2!G37,0)

"pezacide" wrote:

i am trying to create a formule that will calculate certain rates depending
on zones cubic metres and branch. this is what i need to do:

if cell e8=3 and e4 is equal to or less than 30 = shhet2 g37
how would i write this as an excell formula.
also can a Value be a word say
if b9 equals sydney and e4 is equal to or less than 24 =424=150

help with formula
 

You could try this:

=IF(AND(E8=3,E4<=30),Sheet2!G37,"")

Not quite sure about your last example, but you could try this:

=IF(AND(B9="Sydney",E4<=24),424,"")

In both case you will get a blank cell if either condition is not met.

Hope this helps.

Pete

On Sep 27, 12:10 am, pezacide
wrote:
i am trying to create a formule that will calculate certain rates depending
on zones cubic metres and branch. this is what i need to do:

if cell e8=3 and e4 is equal to or less than 30 = shhet2 g37
how would i write this as an excell formula.
also can a Value be a word say
if b9 equals sydney and e4 is equal to or less than 24 =424=150

help with formula
 

=IF(AND(E8=3,E4<=30),Sheet2!G37,IF(AND(E8=3,E4<=30 ),Sheet2!G37,0))

"Pete_UK" wrote:

You could try this:

=IF(AND(E8=3,E4<=30),Sheet2!G37,"")

Not quite sure about your last example, but you could try this:

=IF(AND(B9="Sydney",E4<=24),424,"")

In both case you will get a blank cell if either condition is not met.

Hope this helps.

Pete

On Sep 27, 12:10 am, pezacide
wrote:
i am trying to create a formule that will calculate certain rates depending
on zones cubic metres and branch. this is what i need to do:

if cell e8=3 and e4 is equal to or less than 30 = shhet2 g37
how would i write this as an excell formula.
also can a Value be a word say
if b9 equals sydney and e4 is equal to or less than 24 =424=150

help with formula
 

how would i write lees than 30 but greater than 21

"Mike" wrote:

=IF(AND(E8=3,E4<=30),Sheet2!G37,IF(AND(E8=3,E4<=30 ),Sheet2!G37,0))

"Pete_UK" wrote:

You could try this:

=IF(AND(E8=3,E4<=30),Sheet2!G37,"")

Not quite sure about your last example, but you could try this:

=IF(AND(B9="Sydney",E4<=24),424,"")

In both case you will get a blank cell if either condition is not met.

Hope this helps.

Pete

On Sep 27, 12:10 am, pezacide
wrote:
i am trying to create a formule that will calculate certain rates depending
on zones cubic metres and branch. this is what i need to do:

if cell e8=3 and e4 is equal to or less than 30 = shhet2 g37
how would i write this as an excell formula.
also can a Value be a word say
if b9 equals sydney and e4 is equal to or less than 24 =424=150

help with formula
 

=IF(AND(E8=3,E421,E4<=30),Sheet2!G37,IF(AND(E8=3, E421,E4<=30),Sheet2!G37,0))

"pezacide" wrote:

how would i write lees than 30 but greater than 21

"Mike" wrote:

=IF(AND(E8=3,E4<=30),Sheet2!G37,IF(AND(E8=3,E4<=30 ),Sheet2!G37,0))

"Pete_UK" wrote:

You could try this:

=IF(AND(E8=3,E4<=30),Sheet2!G37,"")

Not quite sure about your last example, but you could try this:

=IF(AND(B9="Sydney",E4<=24),424,"")

In both case you will get a blank cell if either condition is not met.

Hope this helps.

Pete

On Sep 27, 12:10 am, pezacide
wrote:
i am trying to create a formule that will calculate certain rates depending
on zones cubic metres and branch. this is what i need to do:

if cell e8=3 and e4 is equal to or less than 30 = shhet2 g37
how would i write this as an excell formula.
also can a Value be a word say
if b9 equals sydney and e4 is equal to or less than 24 =424=150

help with formula
 

Mike seems to have done the same test twice (and given the same result).

I assume that the second test in the sequence of nested IF functions was
intended to cover the second example.
Perhaps =IF(AND(E8=3,E4<=30),Sheet2!G37,IF(AND(B9="Sydney" ,E4<=24),424,""))
--
David Biddulph

"Mike" wrote in message
...
=IF(AND(E8=3,E4<=30),Sheet2!G37,IF(AND(E8=3,E4<=30 ),Sheet2!G37,0))

"Pete_UK" wrote:

You could try this:

=IF(AND(E8=3,E4<=30),Sheet2!G37,"")

Not quite sure about your last example, but you could try this:

=IF(AND(B9="Sydney",E4<=24),424,"")

In both case you will get a blank cell if either condition is not met.

Hope this helps.

Pete

On Sep 27, 12:10 am, pezacide
wrote:
i am trying to create a formule that will calculate certain rates
depending
on zones cubic metres and branch. this is what i need to do:

if cell e8=3 and e4 is equal to or less than 30 = shhet2 g37
how would i write this as an excell formula.
also can a Value be a word say
if b9 equals sydney and e4 is equal to or less than 24 =424=150