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.
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 …
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.
( Sorry. )
No need to apologize - timestamps tell the facts 
Thanks for the help and clarifications. as you can see I am new to these concepts and will strive to learn 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.