software

Hello folks.

I have the following formula that does do the the required job.
Is it possible for it to be 'tidied up', possibly with a lookup formula.

=IF(Apr!$C5=quot;quot;,quot;Xquot;,IF(Apr!$C5=quot;Holidayquot;,quot;Hol.quot;,IF( Apr!$C5=quot;Sickquot;,quot;Sickquot;,IF(Apr!$C5=quot;Workedquot;,quot;Workquot;,I F(Apr!$C5=quot;Day
Offquot;,quot;D / Oquot;,IF(Apr!$C5=quot;Wrk amp; 1/2 Holquot;,quot;½ Hol.quot;,quot;quot;))))))

Your help is and always has been very much appreciated.
Thanking you in anticipation.
--
Big Rick

If you create a table like this

Holiday Hol
Sick Sick
Worked Work
Day Off D / O
Wrk $ 1/2 Holquot; 1/2 Holput it somewhere off view maybe Y1:Z5 then you can use

=IF(Apr!$C5=quot;quot;,quot;Xquot;,VLOOKUP(Apr!C5,Y1:Z5,2,0))

hard coded it would look like

=IF(Apr!$C5=quot;quot;,quot;Xquot;,VLOOKUP(Apr!C5,{quot;Holidayquot;,quot;Holquot; ;quot;Sickquot;,quot;Sickquot;;quot;Workedquot;,quot;Workquot;;quot;Day
Offquot;,quot;D / Oquot;;quot;Wrk $ 1/2 Holquot;quot;quot;,quot;1/2 Holquot;},2,0))
--

Regards,

Peo Sjoblomquot;Big Rickquot; gt; wrote in message
...
gt; Hello folks.
gt;
gt; I have the following formula that does do the the required job.
gt; Is it possible for it to be 'tidied up', possibly with a lookup formula.
gt;
gt; =IF(Apr!$C5=quot;quot;,quot;Xquot;,IF(Apr!$C5=quot;Holidayquot;,quot;Hol.quot;,IF( Apr!$C5=quot;Sickquot;,quot;Sickquot;,IF(Apr!$C5=quot;Workedquot;,quot;Workquot;,I F(Apr!$C5=quot;Day
gt; Offquot;,quot;D / Oquot;,IF(Apr!$C5=quot;Wrk amp; 1/2 Holquot;,quot;½ Hol.quot;,quot;quot;))))))
gt;
gt; Your help is and always has been very much appreciated.
gt; Thanking you in anticipation.
gt; --
gt; Big Rick
Dear Peo.
I bow down to your superiority.

Fantastic. Thank you very much.
--
Big Rickquot;Peo Sjoblomquot; wrote:

gt; If you create a table like this
gt;
gt; Holiday Hol
gt; Sick Sick
gt; Worked Work
gt; Day Off D / O
gt; Wrk $ 1/2 Holquot; 1/2 Hol
gt;
gt;
gt; put it somewhere off view maybe Y1:Z5 then you can use
gt;
gt; =IF(Apr!$C5=quot;quot;,quot;Xquot;,VLOOKUP(Apr!C5,Y1:Z5,2,0))
gt;
gt; hard coded it would look like
gt;
gt; =IF(Apr!$C5=quot;quot;,quot;Xquot;,VLOOKUP(Apr!C5,{quot;Holidayquot;,quot;Holquot; ;quot;Sickquot;,quot;Sickquot;;quot;Workedquot;,quot;Workquot;;quot;Day
gt; Offquot;,quot;D / Oquot;;quot;Wrk $ 1/2 Holquot;quot;quot;,quot;1/2 Holquot;},2,0))
gt;
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt;
gt; quot;Big Rickquot; gt; wrote in message
gt; ...
gt; gt; Hello folks.
gt; gt;
gt; gt; I have the following formula that does do the the required job.
gt; gt; Is it possible for it to be 'tidied up', possibly with a lookup formula.
gt; gt;
gt; gt; =IF(Apr!$C5=quot;quot;,quot;Xquot;,IF(Apr!$C5=quot;Holidayquot;,quot;Hol.quot;,IF( Apr!$C5=quot;Sickquot;,quot;Sickquot;,IF(Apr!$C5=quot;Workedquot;,quot;Workquot;,I F(Apr!$C5=quot;Day
gt; gt; Offquot;,quot;D / Oquot;,IF(Apr!$C5=quot;Wrk amp; 1/2 Holquot;,quot;½ Hol.quot;,quot;quot;))))))
gt; gt;
gt; gt; Your help is and always has been very much appreciated.
gt; gt; Thanking you in anticipation.
gt; gt; --
gt; gt; Big Rick
gt;
gt;
gt;