sorting with IF formula

  • Thread starter Thread starter Noble
  • Start date Start date
N

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? :confused: I have even tried " " instead of th
zero to leave it blank (my preference).


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


Thank you, Nobl
 
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
 
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
 
Back
Top