Comparing Values in Different Cells

[daisyoso]

Hi anybody can help me with this pls.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Strong[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Weak[/TD]
[TD="align: center"]Result[/TD]
[/TR]
[TR]
[TD="align: center"]O[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]100%[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]O[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75%[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]0
[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

All I want to show is that when I key in "O" in the strong column, I will have a value in the Result as 100%, if I key in "O" in the Medium Column, I will have a value in the result as 75% and so in the Weak column.

Kindly help. Thank you.

 

[Kamolga]

Hi anybody can help me with this pls.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Strong[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Weak[/TD]
[TD="align: center"]Result[/TD]
[/TR]
[TR]
[TD="align: center"]O[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]100%[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]O[/TD]
[TD="align: center"][/TD]
[TD="align: center"]75%[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

All I want to show is that when I key in "O" in the strong column, I will have a value in the Result as 100%, if I key in "O" in the Medium Column, I will have a value in the result as 75% and so in the Weak column.

Kindly help. Thank you.

Hi,

Let's say Strong is cell A1, then in D2 (100%), type

=if(A2="O",100%,if(B2="O",75%,0))

and drag it down

 

[stumac]

This is the access forum - what's a cell?

Seriously though, if your question is about Excel then Kamolga's solution above should work... if not then let us know if you are inputting this in a table (not recommended), a form or a query.

 

[daisyoso]

Hi Kamolga,

Thank you very much for the solution! You are the best!

Let's say Strong is cell A1, then in D2 (100%), type

=if(A2="O",100%,if(B2="O",75%,0))

and drag it down[/QUOTE]

 

[Kamolga]

This is the access forum - what's a cell?

Oups sorry my mistake, indeed I thought I was in Excel forum

 

[Joe4]

Since it appears that this actually was an Excel question, I have moved it to the Excel Questions forum.

Oups sorry my mistake, indeed I thought I was in Excel forum

I am guessing that maybe you stumbled across this question using the "Zero Reply Posts". Note that will show questions from all the forums.
If you look over to the far left of each line, it will list what forum that particular question is found in.

 

[daisyoso]

Hi Kamolga,
Just want to try if you know this.

Cell A1 Cell A2
1-Nov-2017 14-Nov-2017 (I just want that if I key in a date in Cell A1, it will automatically add 14 days in Cell A2. If Cell A1 is 0, Value is should be blank.)

Hope you can help me.
Thank you so much.

 

[Kamolga]

Hi Kamolga,
Just want to try if you know this.

Cell A1 Cell A2
1-Nov-2017 14-Nov-2017 (I just want that if I key in a date in Cell A1, it will automatically add 14 days in Cell A2. If Cell A1 is 0, Value is should be blank.)

Hope you can help me.
Thank you so much.

Hi,

You need to set up A2 as a date and then paste

=IF(A1=0;"";A1+14)

If you want, you can can also use data validation (data tab) so that if user put something else than a date in A1, he will get error message

 

[daisyoso]

Hi Kamolga!

Thank you for the reply and the solution..but it is not semicolon..must be comma..Thank you so much for the help! really appreciate it.