Brain has gone completely blank this morning.
I am trying to create a nested function but keep getting a #VALUE! error and I cannot work out what I have done wrong.
the formula so far looks like this
=IF(SUM(G3*H3)>9,"High",AND(IF(SUM(H3*G3)>5<9,"Medium"),AND(IF(SUM(H3*G3)<5,"Low"))))
G3 and H3 return a value looked up from an array - this part works.
Unfortunately when I try the above formula it works if the value is greater than 9 but I cannot get it to work with over values.
What obvious thing am I doing wrong?
I am trying to create a nested function but keep getting a #VALUE! error and I cannot work out what I have done wrong.
the formula so far looks like this
=IF(SUM(G3*H3)>9,"High",AND(IF(SUM(H3*G3)>5<9,"Medium"),AND(IF(SUM(H3*G3)<5,"Low"))))
G3 and H3 return a value looked up from an array - this part works.
Unfortunately when I try the above formula it works if the value is greater than 9 but I cannot get it to work with over values.
What obvious thing am I doing wrong?