| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
