mardi 6 juin 2017

Excel If value in Cell is 181 then I want to display value in F28

I've tried the following but it doesn't seem to work

=IF(D28="181", "",F28)

I'm making a filter to display a value in a column of cells the the associated row value is 181, basically I have a bunch of data and column D identifies the type of data. So I want to know if D(#)=181 if it does display the column value from F#

but it doesn't seem to mater what value I have in D it always outputs something in the cell when it should be empty.

Aucun commentaire:

Enregistrer un commentaire