Prince,
But my column C Prod (On+Off Rte) wrote:
> =IF(IF(ISERROR(C2/A2),"",(C2/A2))>=1,"100%","")
>
> Regards
> Prince
>
> On Tuesday, 5 March 2013 16:31:37 UTC+5:30, Shaikh Iqbal wrote:
>
>> Prince
>>
>> If Column *C* Prod (On+Off Rte) > CallPlan then output in column D only
>> 100% not goes to
=IF(IF(ISERROR(C2/A2),"",(C2/A2))>=1,"100%","")
Regards
Prince
On Tuesday, 5 March 2013 16:31:37 UTC+5:30, Shaikh Iqbal wrote:
>
> Prince
>
> If Column *C* Prod (On+Off Rte) > CallPlan then output in column D only
> 100% not goes to 126%
>
>
>
>
> On 5 March 2013 16:15, Prince > wrote:
>
>> if
Prince
If Column *C* Prod (On+Off Rte) > CallPlan then output in column D only
100% not goes to 126%
On 5 March 2013 16:15, Prince wrote:
> if i m right you may be expecting this :
>
> =IF(IF(ISERROR(ROUND(C2/A2%,2)),0,(ROUND(C2/A2%,2)))=100%,IF(ISERROR(ROUND(C2/A2%,2)),0,(ROUND(C2/A2%,2))),
ed colour.
>
>
> -- Forwarded message --
> From: अनिल नारायण गवली
> Date: Fri, Nov 30, 2012 at 12:26 PM
> Subject: Re: $$Excel-Macros$$ Re: Formula need to calculate sum on
> conditional base
> To: excel-macros@googlegroups.com, Ashish Bhalara <
> ashishbhalar...@gmail.co
Pls find attched sheet for you reference.
Regards,
Gawli Anil
On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara
wrote:
> i need the formula for text enetered in sheet with red color
>
> On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara <
> ashishbhalar...@gmail.com> wrote:
>
>> Dear expert,
>>
>>
Hi,
PFA...
Thanks and Regards,
Somnath C Pardeshi
From: Ashish Bhalara
To: excel-macros@googlegroups.com
Sent: Friday, 30 November 2012 12:16 PM
Subject: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base
i need the formula for text e
pls share the workbook with us
On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara
wrote:
> i need the formula for text enetered in sheet with red color
>
> On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara <
> ashishbhalar...@gmail.com> wrote:
>
>> Dear expert,
>>
>> I have a data in attached sheet,
