Word in a cell, for a number in adjacent

Vincy - Aug 19, 2011 at 01:04 AM
 Vincy - Aug 19, 2011 at 06:25 AM

I am Vinay and I am working on an excel sheet to create a format for purchase order.
I am stuck at a point, please help.

I want a formula, which will give me a word (Example: $) in the adjacent cell whenever I write any number in the cell. It should be blank if there is no number on the adjacent cell.

Example A1 is blank and in B2 I write 20000, so A1 should automatically show $ sign, or else it should be blank.

Please mates, help.


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 19, 2011 at 06:01 AM
But my maths teacher used to tell us that point has no width, no length. So how can you be stuck on a point ?
Ok lame joke aside, you need to use a formula
=IF(B2="", "", "$")

but why not format B column to show $ ?
Hah hha.. nice joke.. but I said stuck "at a point".. not "on a point".. :D

Anyways.. thanks mate.. it works.. and I think this solves my problem..

Formatting column B to show $ wouldn't help me.. coz I want that whenever I put a numerical figure in the particular cell only then the adjacent cell should show $ or else it should be blank.. but this is working just fine... :D

U can add me on facebook - I am there as vinay chaudhary (vinaychaudhary.in%gmail.com) (replace % with @)

Thanks Again !! :D