#VALUE! error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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",""))
 
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
 
Thanks folks, thats the one. Amazing the differance a well placed paran here
and a moved comma there can make! ;-) L8rs.
 
Back
Top