Validating a Cell
My columns look like:
P/NP Copay Basis Copay - 90 day P R $100.00 P M $85.00 I want to validate the entry into the Copay-90 day column. If "P/NP" is equal to P and copay basis is equal to M, the value of the Copay-90 day column cannot exceed $85. If it is more, I'd like to see an error message. Can someone help me with this? -- Lady |
Validating a Cell
Hi,
This is a task for Data, Validation. Select the Copay cells and choose Data, Validation. Pick Decimal from the Allow list, Choose Between from Data, enter 0 or whatever is appropriate for the Minimum and for the Maximum enter =IF(AND(A3="P",B3="m"),85) Here I am assuming that A3 is the first cell under P/PN, B3 contains the first Copay Basis and you have select from C3 down. You can add a custom message on the Error Alerts tab There are other variations that will do it also. -- Thanks, Shane Devenshire "Lady Success" wrote: My columns look like: P/NP Copay Basis Copay - 90 day P R $100.00 P M $85.00 I want to validate the entry into the Copay-90 day column. If "P/NP" is equal to P and copay basis is equal to M, the value of the Copay-90 day column cannot exceed $85. If it is more, I'd like to see an error message. Can someone help me with this? -- Lady |
All times are GMT +1. The time now is 02:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com