how to update using function

[mango]

dear all, hope can help. thanks in advance.

1) how to update those cell with unknown if the cell is blank?

Centre
K112
K342
unknown
K687
K860
K345
K770
unknown
K992
K942
unknown
K02330

2) how to update the cell in credit column with 0 for those cell no value?
if debit with value then credit column must fill in 0.

Debit Credit Credit column must be like this
169.51 0
11,265.70 0
23,541.70 0
0 500 500
3,664.77 0
817.96 0
33.28 0
0 76 76
481.16 0
12,904.70 0

 

[Govind]

Hi,

For the first issue, you can select the column and do a find &
replace.Find blank(enter as "") adn enter replace with as "unknown"

For the second issue, you can add a helper column and enter this formula
= IF(C1="",0,C1)

where C1 is the column where the credit numbers are there.

Or you can use a find & replace for this well.Find blank and replace it
with zero.

Regards

Govind

 

[mango]

thanks govind but find and replace cannot work. i even highlighted the
portion to find and replace but still cannot.
anyway, if statement is very helpful.
sorry i have a limited knowledge on excel.
thanks

 

[Govind]

Hi,

You can use the if condition for the first case as well.

Lets say the data is in column A, insert a column(col B) next to column
A and enter the formula in column B

=IF(A1="","unknown",A1)

And paste it down.

Then copy the column B and paste it over column A using paste special -
Values.

Regards

Govind.