View original (French)

If in sheet1 cell C5 is not equal to 0 copy the text from

Toff8 Posted messages 12 Status Member -  
Toff8 Posted messages 12 Status Member -
Hello,
I have a file that contains a set of data.
These are all questions where the answers are yes or no.
This file is on my second sheet. On sheet 1, I am taking final scores from several results.
These are all averages.
Of course, the averages "smooth" the result... but that's not the issue here.
I would like each time a result is negative for it to appear on my first sheet. Basically, I want to know a formula that says: if on sheet 2 cell C5 is different from 0, copy the text from sheet 2 cell B5 to sheet 1 cell C10.
Thank you very much!!!!

4 answers

  1.
    fabien25000 Posted messages 697 Status Member 59
     
    Hello,

    =IF(C5<>0, B5, "")
    in French: if B5 is different from 0 then value of B5 else nothing

    --
    When you only have a hammer, all problems look like a nail.
    2
    1. Toff8 Posted messages 12 Status Member
       
      Thank you, the formula works very well. However, I would like it so that if B5, C5, or D5 is different from 0 or empty, then copy the text from B6...
      0