IF function

A

ALex

I have issues when dealing with the IF function (to sure it should be IF or
PRODUCT):

A,H,J,M are text cells and C= to number cells

when
(H1:H1000=J1) AND (A1:A1000=M1) Then C1='1000-1'
(H1:H1000=J1) AND (A1:A1000=M2) Then C1='1000-2'
(H1:H1000=J1) AND (A1:A1000=M3) Then C1='1000-3'
(H1:H1000=J1) AND (A1:A1000=M4) Then C1='1000-4'

(H1:H1000=J2) AND (A1:A1000=M1) Then C1='2000-1'
(H1:H1000=J2) AND (A1:A1000=M2) Then C1='2000-2'
(H1:H1000=J2) AND (A1:A1000=M3) Then C1='2000-3'
(H1:H1000=J2) AND (A1:A1000=M4) Then C1='2000-4'

(H1:H1000=J3) AND (A1:A1000=M1) Then C1='3000-1'
(H1:H1000=J3) AND (A1:A1000=M2) Then C1='3000-2'
(H1:H1000=J3) AND (A1:A1000=M3) Then C1='3000-3'
(H1:H1000=J3) AND (A1:A1000=M4) Then C1='3000-4'


help please?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumproduct() function resulted in an error #DIV/0 2
Conditional Time Calculation 10
Sum of an array 1
Sum of an array 4
SIMPLE DRAGGING issue 1
help with 12 week rolling average 3
SUMS 1
Need a proper guru! My head hurts ;( 1

Top