Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problems with an IF statement
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement | New Users to Excel | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) |