Dear Experts,
pl suggest any formula which can help me to get valeus for K2 & L2 from raw
sheet against B2 & C2
Note:- kindly Refer the hours which stand within StartTime & EndTime
sheet attached for reference
Thnaks in advance.
rakesh Sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Dear Shayam,
Please share a sample sheet.
On Thu, Aug 2, 2012 at 1:45 PM, Anera Shyam wrote:
> Hi All,
>
> I Dont think I have the syntax right..here is what am trying, If the
> result of the Lookup is "Extended" and the subsequent look-up outputs are
> between 1 to 5 should show as R, between
Hi All,
I Dont think I have the syntax right..here is what am trying, If the result
of the Lookup is "Extended" and the subsequent look-up outputs are between
1 to 5 should show as R, between 5 to 7 as Y and >8 as G Or If the Lookup
value is "Monthly" and the subsequent look-up outputs are 1=R, 2=
