Ask Your Question
0

If and copy in spreadsheet

asked 2018-08-19 20:18:58 +0200

Barrowman gravatar image

I have Column A with names in it. Column D contains values fro 0 to 100. Suppose in row 25 I have John in A25 and zero (0) in D25 I want I25 to have a copy of A25. Is there some way to do this?

edit retag flag offensive close merge delete

Comments

What is the rule for I25 cell? I mean, you want to "mirror" A25 in I25 because A25 value is "Jonh" or because D25 is 0, or because both conditions are true. Or something else to be considered?

SM_Riga gravatar imageSM_Riga ( 2018-08-19 20:57:10 +0200 )edit

If D25 is zero then I want I25 to mirror A25

Barrowman gravatar imageBarrowman ( 2018-08-20 08:35:41 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-08-20 09:17:23 +0200

Barrowman gravatar image

Well the example in help is different to what I get if I insert a function. Like this: Help says IF(Test; ThenValue; OtherwiseValue) Creating a function shows this: IF(Test, ThenValue, OtherwiseValue) i.e comma not semi-colon The function one works BUT if I later delete the zero in D25 it still shows A25 in I25 unless I put a different value, even a space character in D25 so it's still not what I want. Any idea how I can fix this?

edit flag offensive delete link more

Comments

This is not an answer to the original question, so please post it as a comment to your question above. And please also add info, how your actual formula in I25 does look like. Should be something like =IF(D25=0,A25,0), although I do not know what OtherwiseValue you want to have in case D25 is not 0. Empty cell has value (not text string) of 0, so deleting (emptying) cell contents leaves it's value 0, that is why test D25=0 still returns True.

SM_Riga gravatar imageSM_Riga ( 2018-08-20 11:29:08 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-19 20:18:58 +0200

Seen: 26 times

Last updated: Aug 20 '18