IF

ProvRobbie · May 9th, 2002, 10:45 AM

I know that IF can be usd to determine if a condition is true or false, but can it be used to detrmine if there is text in a field or not?

Example: I want to interrogate column A, if there is text in the cell interrogated (say A10) I want to put text into F10 (either "VAT" or "NIL")

Does anyone have a way of doing this?

Thanks,

Robbie

klb · May 9th, 2002, 10:47 AM

You could use the functin ISTEXT().

IF(ISTEXT(A1),"YOUR MESSAGE","")

Nimrod · May 9th, 2002, 10:49 AM

Try the ISBLANK & ISTEXT FUNCTIONS
IE IF(ISBLANK(A10), "true func", False func)

Jay Petrulis · May 9th, 2002, 10:50 AM

F10: =IF(ISTEXT(A10),"VAT","NIL")

There is also an ISNUMBER function and a host of others under the Information category of Excel functions.

HTH,
Jay

ProvRobbie · May 9th, 2002, 10:52 AM

We're not worthy!!!

Thanks, works a treat.

May 9th, 2002, 10:49 AM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Try the ISBLANK & ISTEXT FUNCTIONS IE IF(ISBLANK(A10), "true func", False func) __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 10:45 AM	#1
ProvRobbie New Member Join Date: May 2002 Posts: 7	I know that IF can be usd to determine if a condition is true or false, but can it be used to detrmine if there is text in a field or not? Example: I want to interrogate column A, if there is text in the cell interrogated (say A10) I want to put text into F10 (either "VAT" or "NIL") Does anyone have a way of doing this? Thanks, Robbie

May 9th, 2002, 10:47 AM	#2
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	You could use the functin ISTEXT(). IF(ISTEXT(A1),"YOUR MESSAGE","")

May 9th, 2002, 10:50 AM	#4
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	F10: =IF(ISTEXT(A10),"VAT","NIL") There is also an ISNUMBER function and a host of others under the Information category of Excel functions. HTH, Jay

May 9th, 2002, 10:52 AM	#5
ProvRobbie New Member Join Date: May 2002 Posts: 7	We're not worthy!!! Thanks, works a treat.