(SOLVED)IF then statements

frog_15537 · Posted: Wed Sep 28, 2011 4:22 am Post subject: (SOLVED)IF then statements

Wonder if some one can help me with this spreadsheet problem. I have a spreadsheet with ten columns and lets say ten rows.

I would like to compare the values in A1 through J1 against the value 1. If any value in any of those ten cells equals 1, I would like to place a “Y” in L1. If it none equal 1 I would like to place a “N” in L1. all ten values will be different so that there can only be one 1 if there are any.

Can this be done? How?

What I tried was

If(A1:J1 =1; “Y”; “N”)

what that give me is “#Value”

Thanks for any help.

Bill

Villeroy · Posted: Wed Sep 28, 2011 4:56 am Post subject:

gerard24 · Posted: Wed Sep 28, 2011 5:00 am Post subject:

frog_15537 · Posted: Wed Sep 28, 2011 5:10 am Post subject: If then statement

My apologies Villeroy but I don't understand what it is that you are suggesting.

are you asking a questions about my if statement

clarification

I want to check each individual cell A1 through J1 against the value of 1. if in any one of those individual cells there is a 1, I want to put a Y in L1. Otherewise I want to put an N.

I tried putting in the :"then" and the "else" in the statement but that doesn't help.

Not sure what you meant by "10 values".

My knowledge of Calc is very limited.

thanks for trying

Bill

frog_15537 · Posted: Wed Sep 28, 2011 5:29 am Post subject: If then statement

thank you very muchy gerard24. that works just the way I wanted it too.

thanks to all who looked and especially to those who answered me.

Bill