# Conditional Calculation of Value

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 close merge delete

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 ...

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

Sort by » oldest newest most voted

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.

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.

more

( Sorry. )

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

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

( 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!

( 2020-02-15 22:41:35 +0200 )edit

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.

more

=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.

more