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?

Maybe you meant to do this:
=IF(I9="y","mm Used This Job",IF(K9="y","cm Used This Job",""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dim" wrote:
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?

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

On Oct 10, 1:04 pm, dim wrote:
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?

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