sorting with IF formula

[Noble]

I am trying to sort fees into seperate columns.
C19 is text and F19 is currency.

I want it to say if *the name of the fee type* is "insertion fee" tak
the amount that is in the *fee charged* column and if it isn't a
insertion fee, leave it blank.

I have made this formula work in row C but when I COPY it, or even jus
type it into the next row, it is a zero instead of the dollar amount
What am I doing wrong? I have even tried " " instead of th
zero to leave it blank (my preference).


=IF($C19="insertion",$F19,0)


Thank you, Nobl

 

[Martin]

=IF($C19="insertion",$F19,"")
enjoy

 

[Noble]

It worked perfectly in row 19 but when I copied down it doesn't work.
I've used formulas for a long time and not had this problem. Could it
have anything to do with the fact that the fee is a negative amount?

Noble

 

[Max]

Try using TRIM() to wrap around $C19, e.g.:

: =IF(TRIM($C19)="insertion",$F19,0)

TRIM enables more robustness in checking of text strings
It will remove any extraneous "invisible" spaces
e.g.: leading and trailing spaces