Ask Your Question
0

Conditional Calculation of Value

asked 2020-02-14 23:43:49 +0200

jp2 gravatar image

updated 2020-02-15 00:03:01 +0200

Opaque gravatar image

I need formula involving three cells in a given row. The numeric value of the first cell need to be coppied to the third cell when the value of the second cell is"0"

[Edit- Opaque] Changed title to summarize details and not being a duplicate of the details.

edit retag flag offensive close merge delete

Comments

Please try to find short titles for your questions. It doesn't make much sense to have title and details the same content. Thanks in advance ...

Opaque gravatar imageOpaque ( 2020-02-15 00:01:31 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2020-02-14 23:54:47 +0200

Opaque gravatar image

updated 2020-02-14 23:55:46 +0200

Hello,

First of all - formulas don't copy anything but reference content from other cells and show the content based on the functionality of the formula.

Regarding your problem:

Assume cell A1 holds a value, cell B1 holds the value, where the conditions is based on and cell C1 has the value, of A1, if the conidtion is met, then write the following formula into C1:

=IF(B1=0;A1;"")

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more

Comments

( Sorry. )

Lupp gravatar imageLupp ( 2020-02-14 23:55:34 +0200 )edit

No need to apologize - timestamps tell the facts ;-)

Opaque gravatar imageOpaque ( 2020-02-15 00:04:47 +0200 )edit

Thanks for the help and clarifications. as you can see I am new to these concepts and will strive to learn more!

jp2 gravatar imagejp2 ( 2020-02-15 22:41:35 +0200 )edit
0

answered 2020-02-15 01:44:15 +0200

Allows calculations to be conducted only on those numbers that satisfy a certain condition. If a condition is true and a different value if the condition is false, a conditional formula returns one value. Using the When rule Editing and Proofreading Services, you can construct a conditional formula.

edit flag offensive delete link more
0

answered 2020-02-14 23:54:49 +0200

Lupp gravatar image

=IF(B2=0;A2;"This poor formula was not told what should be placed in the third cell if b<>0")
Formulas don't "copy" anything but return a result. The IF() function should always also have an Else position. Otherwise it will return FALSE if the condition not comes out TRUE.
The critical value of the second cell was supposed to be the number 0. If actually the text "0" was meant the formula needs respective correction.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-02-14 23:43:49 +0200

Seen: 51 times

Last updated: Feb 15