stephen.smith
Board Regular
- Joined
- Jul 7, 2010
- Messages
- 119
Hey Guys
I am trying to perform an if formula on a cell but am running into a few problems. There a three options with the cell, one is that it is blank and has no information, one is that it will contain the number 1, and one is that it will contain the number 2.
What I would like to happen is that if the cell is blank it remains blank, if it has the value 1 that it returns the word "alert" and if it has the value 2 that it returns the word "ok".
Has anyone any idea how to this.
Thanks again in advance to anyone that can help.
Stephen
I am trying to perform an if formula on a cell but am running into a few problems. There a three options with the cell, one is that it is blank and has no information, one is that it will contain the number 1, and one is that it will contain the number 2.
What I would like to happen is that if the cell is blank it remains blank, if it has the value 1 that it returns the word "alert" and if it has the value 2 that it returns the word "ok".
Has anyone any idea how to this.
Thanks again in advance to anyone that can help.
Stephen
