#VALUE! error

[dim]

Hi...again...Im sure this is really simple....

I've put in a formula:
=IF(I9="y","mm Used This Job"),IF(K9="y","cm Used This Job")

It works fine until the second IF, then I keep getting a #VALUE! regardless
whether the letter 'y' is in the relevant cell.

Any ideas?

 

[Max]

Maybe you meant to do this:
=IF(I9="y","mm Used This Job",IF(K9="y","cm Used This Job",""))

 

[Pete_UK]

Try it this way:

=IF(I9="y","mm Used This Job",IF(K9="y","cm Used This Job",""))

You'll get a blank if neither of the cells contain a y.

Hope this helps.

Pete

 

[dim]

Thanks folks, thats the one. Amazing the differance a well placed paran here
and a moved comma there can make! ;-) L8rs.