Related:
- Word in a cell, for a number in adjacent
- Number to text in word - Guide
- Insert a tick in word - Guide
- How to insert a line in word for resume - Guide
- Number to word in excel - Guide
- Word apk for pc - Download - Word processors
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
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 $ ?
Ok lame joke aside, you need to use a formula
=IF(B2="", "", "$")
but why not format B column to show $ ?
Aug 19, 2011 at 06:25 AM
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