change data by formula?

[ajkiwi88]

hi
i am currently doing an A's project for ict and i have a list and want to produce an invoice so i want a formula which say if the value in a certain cell read n/a then place " " in this cell (or leave it blank) is it possible if so how?

cyaz
aj

[Domenic]

Try the following...

=IF(A1="n/a","","undetermined")

So in this case, if A1 contains n/a, the formula will return a blank, otherwise it will evaluate the third arguement, which in this example is undetermined since you haven't specified anything.

Hope this helps!

hi
i am currently doing an A's project for ict and i have a list and want to produce an invoice so i want a formula which say if the value in a certain cell read n/a then place " " in this cell (or leave it blank) is it possible if so how?

cyaz
aj

[ajkiwi88]

so what would i put on the end if i wanted it to display what was in the cell if it isn't n/a?

thanks for your help
cyaz
aj

[Domenic]

so what would i put on the end if i wanted it to display what was in the cell if it isn't n/a?

thanks for your help
cyaz
aj

=IF(A1="n/a","",A1)

Hope this helps!

[ajkiwi88]

yeah thanks so much cheers

cyaz
aj