Tech Support Guy banner
Status
Not open for further replies.

validation based on another cell

625 views 1 reply 2 participants last post by  Keebellah 
#1 ·
I have a spread sheet where I would like a message to pop up after I enter a value in cell G2 based on what the value of I2 is. like the following description:
In cell I2 I have "=(E2*F2*G2)/144" after I enter a value in cell G2 I want a message to come up if the value of I2/g2 is less than three and not equal to zero" Is this possible? If so could someone help me out with this?

thanx
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top