IF

[ProvRobbie]

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]

You could use the functin ISTEXT().

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

 

[Nimrod]

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

 

[Jay Petrulis]

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]

We're not worthy!!!

Thanks, works a treat.