=if(or(A1="Vacation",A1="Sick"),8,0)
HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.


"lisaw" wrote:

I am trying to create a formula that will calculate employee vacation and
sick time used. Is anyone aware of a formula that will allow me to calculate
text for value??