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
|