Help with If Function
Maybe...
=IF(and(A319,B317),1,IF(and(A329,B3<17),2,
IF(and(A3<29,B317),3,IF(and(A3<29,B3<17),4))))
But it looks like you're missing a value (when B3=17, for example).
maybe...
=IF(AND(A319,B317),1,IF(AND(A329,B3<17),2,
IF(AND(A3<29,B317),3,IF(AND(A3<29,B3<17),4,"whatg oeshere"))))
ps. I changed your text numbers to number numbers.
Joy wrote:
Can someone help me fix this because it doesn't seem to work and I don't know
where to go from here?
=IF(A319&B317,"1",IF(A329&B3<17,"2",IF(A3<29&B3 17,"3",IF(A3<29&B3<17,"4"))))
--
Thanks, Joy
--
Dave Peterson
|