- Joined
- Oct 22, 2007
- Posts
- 836
- Reaction score
- 11
Ok guys I hope someone is good with excel because I'm getting all confused and I'm sure it shouldn't be this complex.
Anyway I want a cell to display the following messages: WP Close (less than 61), Delete (less than 1), Active (61 or more).
The way this is done is by calculating numbers.
So lets says cell A1 is where I want the message it will look at the number in B1
If B1 states between 1 and 60 then the message should display WP Close
If B1 states less than 1 (to include any minus figure such as -2532 for example) then the message should display Delete
If B1 states 61 or more then the message should display Active
What is the formula I need in the cell A1 for this to happen?
I've tried lots of different ways and I just can't seem to get it right.
Anyway I want a cell to display the following messages: WP Close (less than 61), Delete (less than 1), Active (61 or more).
The way this is done is by calculating numbers.
So lets says cell A1 is where I want the message it will look at the number in B1
If B1 states between 1 and 60 then the message should display WP Close
If B1 states less than 1 (to include any minus figure such as -2532 for example) then the message should display Delete
If B1 states 61 or more then the message should display Active
What is the formula I need in the cell A1 for this to happen?
I've tried lots of different ways and I just can't seem to get it right.
