|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 24th, 2006, 04:06 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Forumla to recognize text
I'm trying to use a basic IF THEN statement but I need the IF function to
recognize whether there is text in a cell or if its blank. =IF(cellA2 has text, forumla,"") In other words, if cell A2 is blank I want the cell with the formula in it blank. If A2 has text written in it, I want the cell with the formula to use another formula. How can I accomplish this? 
|
|
#2
January 24th, 2006, 04:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Forumla to recognize text
Maybe the reverse would be easier:
=IF(ISBLANK(A2),"",your_formula) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Woody13" wrote: I'm trying to use a basic IF THEN statement but I need the IF function to recognize whether there is text in a cell or if its blank. =IF(cellA2 has text, forumla,"") In other words, if cell A2 is blank I want the cell with the formula in it blank. If A2 has text written in it, I want the cell with the formula to use another formula. How can I accomplish this?
|
|
#3
January 24th, 2006, 04:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Forumla to recognize text
Try something like:
=IF(A2="","",IF(ISTEXT(A2),your formula,"")) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Woody13" wrote in message ... I'm trying to use a basic IF THEN statement but I need the IF function to recognize whether there is text in a cell or if its blank. =IF(cellA2 has text, forumla,"") In other words, if cell A2 is blank I want the cell with the formula in it blank. If A2 has text written in it, I want the cell with the formula to use another formula. How can I accomplish this?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Newbie table Layout (Posted as suggested by Tom Lake for feedback) | Little Penny | Using Forms | 2 | December 25th, 2005 04:44 PM |
| Is Access even the right idea? | BMB | New Users | 19 | November 21st, 2005 08:01 PM |
| Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
| Change font of part of text | John | Powerpoint | 7 | March 15th, 2005 10:10 AM |
| Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Linear Mode
