Thanks, that works except....when I paste it into the formula window I
am exceeding some sort of limit.
I am pasting:
=IF(AND(Sheet1!B2=1,Sheet1!C212),(Sheet1!A2*0.1), IF(AND(Sheet1!B2=2,Sheet1!C210),(Sheet1!A2*0.1),I F(AND(Sheet1!B2=3,Sheet1!C28),(Sheet1!A2*0.1),IF( AND(Sheet1!B2=4,Sheet1!C27),(Sheet1!A2*0.1),IF(AN D(Sheet1!B2=5,Sheet1!C26),(Sheet1!A2*0.1),IF(AND( Sheet1!B2=6,Sheet1!C25),(Sheet1!A2*0.1),IF(AND(Sh eet1!B2=7,Sheet1!C24),(Sheet1!A2*0.1),IF(AND(Shee t1!B2=8,Sheet1!C23),(Sheet1!A2*0.1),IF(AND(Sheet1 !B2=9,Sheet1!C23),(Sheet1!A2*0.2),IF(AND(Sheet1!B 2=10,Sheet1!C22),(Sheet1!A2*0.3),IF(AND(Sheet1!B2 =11,Sheet1!C22),(Sheet1!A2*0.4),IF(AND(Sheet1!B2= 12,Sheet1!C21),(Sheet1!A2*0.5),0))
but it only shows:
=IF(AND(Sheet1!B2=1,Sheet1!C212),(Sheet1!A2*0.1), IF(AND(Sheet1!B2=2,Sheet1!C210),(Sheet1!A2*0.1),I F(AND(Sheet1!B2=3,Sheet1!C28),(Sheet1!A2*0.1),IF( AND(Sheet1!B2=4,Sheet1!C27),(Sheet1!A2*0.1),IF(AN D(Sheet1!B2=5,Sheet1!C26),(Sheet1!A2*0.1),IF(AND( Sheet
With line breaks so that it is easier to read and understand, what I'm
trying to accomplish is:
=IF(AND(Sheet1!B2=1,Sheet1!C212),(Sheet1!A2*0.1),
IF(AND(Sheet1!B2=2,Sheet1!C210),(Sheet1!A2*0.1),
IF(AND(Sheet1!B2=3,Sheet1!C28),(Sheet1!A2*0.1),
IF(AND(Sheet1!B2=4,Sheet1!C27),(Sheet1!A2*0.1),
IF(AND(Sheet1!B2=5,Sheet1!C26),(Sheet1!A2*0.1),
IF(AND(Sheet1!B2=6,Sheet1!C25),(Sheet1!A2*0.1),
IF(AND(Sheet1!B2=7,Sheet1!C24),(Sheet1!A2*0.1),
IF(AND(Sheet1!B2=8,Sheet1!C23),(Sheet1!A2*0.1),
IF(AND(Sheet1!B2=9,Sheet1!C23),(Sheet1!A2*0.2),
IF(AND(Sheet1!B2=10,Sheet1!C22),(Sheet1!A2*0.3),
IF(AND(Sheet1!B2=11,Sheet1!C22),(Sheet1!A2*0.4),
IF(AND(Sheet1!B2=12,Sheet1!C21),(Sheet1!A2*0.5),0 ))
Is there a more elegant way to do this?
--
pdgood
------------------------------------------------------------------------
pdgood's Profile:
http://www.excelforum.com/member.php...o&userid=31623
View this thread:
http://www.excelforum.com/showthread...hreadid=534656