I am trying to re write a formula in Excel and I am having an issue with
it.

the forumlat needs to compare a job code then if that job code matches
(D%) it will then populate that cell with the hours worked (A5)


This is the orginal

=IF(D5-11030=0,A5,IF(D5-11050=0,A5,IF(D5-106030=0,A5,IF(D5-106050=0,A5,IF(D5-108100=0,A5,IF(D5-401010=0,A5,IF(D5-441010=0,A5,IF(D5-481010=0,A5,"
"))))))))


I need to ad 3 new codes.

010120
411010
107130


So this is the formula I wrote.

=IF(D5-11030=0,A5,IF(D5-11050=0,A5,IF(D5-106030=0,A5,IF(D5-106050=0,A5,IF(D5-108100=0,A5,IF(D5-401010=0,A5,IF(D5-441010=0,A5,IF(D5-481010=0,A5,*IF*(D5-010120=0,A5,IF(D5-411010=0,A5,IF(D5-107130=0,A5,"
")))))))))))

but is seams Excel does not like this. Even if I enter the information
at the begining it will error and highlite If number 9 (the one in
bold) What am I doing wrong? I need a way that works with all 11 codes.


--
Amaloney
------------------------------------------------------------------------
Amaloney's Profile: http://www.excelforum.com/member.php...o&userid=27283
View this thread: http://www.excelforum.com/showthread...hreadid=467914