View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lady Success Lady Success is offline
external usenet poster
 
Posts: 28
Default 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