View original (French)

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

Toff8 Posted messages 12 Status Membre -  
Toff8 Posted messages 12 Status Membre -
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 réponses

Réponse 1 / 4
fabien25000 Posted messages 697 Status Membre 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
Toff8 Posted messages 12 Status Membre
 
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