ProvRobbie
New Member
- Joined
- May 8, 2002
- Messages
- 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
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