Hi All,
Please help me out on this formula.
I would require an expanation for each action taken by formula.
=IF(($J$16-ROW())*10+11*(IF($H$16="R",0,1)) +
(-1)^(IF($H$16="R",0,1))*(($L$16-COLUMN())+1)<=$D$16,1,"")
Attached is the file for reference.
--
Regards,
SACHIN OR
--
--
a "1" appears in E6, and the
conditional formatting turns the cell magenta.
hope this helps break down the formula.
however, I STILL have no idea WHY someone would want to do this!!!
Paul
From: sachin or
To: excel-macros@googlegroups.com
Sent: Wed,
lank ("") and the
> conditional formatting turns the cell grey.
> if H16 does NOT = "R", then a 40 IS <= 45, a "1" appears in E6, and the
> conditional formatting turns the cell magenta.
>
> hope this helps break down the formula.
>
> however, I S
like you don't understand mathematical expressions.
It may be that you need to look into that.
Paul
From: sachin or
To: excel-macros@googlegroups.com; schreiner_p...@att.net
Sent: Fri, May 21, 2010 7:33:58 AM
Subject: Re: $$Excel-Macros$$ What does this for