Names and such

[medicenpringles]

is there any way to get exel to understand the letters "CL" as the number 10?

i set the name CL to equal 10, but when i put that in a cell and hit "enter", it changes to 10 instead of displaying "CL"

maybe some VBA?

thanks,
stephen

[keithl816]

Assuming that 10 is in cell a1, put the following in cell b1

CODE]

=IF(a1=10,"cl","")

[/CODE]

Hope this helps

[medicenpringles]

well, sorta.

what happens is i have a formula that subtracts A1 from B1 and i need to, for instance, return 5 if i type 9 in A1 and CL in B1.

anyone?

[keithl816]

Can you post an example?