Formula - How to set a numeric value to a text entry

**zuwoni** · 03-22-2011, 09:29 AM

does anyone know how to set a numeric value to a text entry?

example
cell 1 "case", is it possible to get cell a2 to return a result of 12?

thanks in advance for the help!

**Andy Pope** · 03-22-2011, 09:31 AM

Why 12? I think you need to explain further.

**zuwoni** · 03-22-2011, 11:41 AM

12 was just a random number. I just need the word "case" to equal a set value in another cell - if thats possible.

**Andy Pope** · 03-22-2011, 11:44 AM

=IF(A1="Case",12,"")

Formula - How to set a numeric value to a text entry

LinkBack

Thread Tools

Rate This Thread

Display

Formula - How to set a numeric value to a text entry

Re: Formula - How to set a numeric value to a text entry

Re: Formula - How to set a numeric value to a text entry

Re: Formula - How to set a numeric value to a text entry

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions