Hi Ashish
Thanks Unfortunatily i got this formula from you thanks from 3-4 days i
try to finding this formula once again thanks.
i appreciate you will be help me in future
thanks
On Tue, Apr 28, 2009 at 8:43 PM, Ashish Jain <26may.1...@gmail.com> wrote:
>
> Hi Savant,
>
> Try this fo
Hi Savant,
Try this formula:
==IF(OR(AND(ISNUMBER(FIND(LEFT(B2,1),"JCR")),IF(SUM(COUNTIF(C2,
{"DST","LVN","DNM"}))>0,TRUE,FALSE)),OR( ISNUMBER(FIND(LEFT
(B2,1),"AWFUY")),ISNUMBER(FIND("SHORT", G2)),IF(SUM(COUNTIF(C2,
{"BOG","BLM","CMO"}))>0,TRUE,FALSE))),I2-0.01,J2)
Regards
Ashish Jain
www.exce
