Excel 2003 formula help

[steve45]

Hi i'm having a bit of bother with excel, i've been tearing my hair out the last hour or so trying and failing to work this out

i have a table showing equipment states(Fit, Ltd and U/S), these are auto populated from another sheet using a VLookup formula, i need a formula to work out when the cell D4 in this case is showing the value "FIT" then the cell next to it D5 will auto populate with a number, lets just say for example FIT=10, LTD=5 and U/S=0. please put me out of my misary my brain is completely stumped i'm sure its sitting there staring at me in the face but its just not coming to me.

any help on this issue will be greatly appreciated!

 

[dazzerd]

=if(d4="FIT",10,If(d4="LTD",5,if(d4="U/S",0)))

That will work problem is 2003 is limited to 8 nested "if" functions so if you have more then 8 conditions then you will have to use another method.

 

[steve45]

You sir are a legend, thank you!