formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

highlander_jlp - 20 Sep 2006 00:16 GMT

a b c
d
1 Mon 0    0.00% 100% 100%
2 Tue -5141    -7.32%    93% 100%
3 Wed -5181    -7.84%     92% 100%
4 Thu 0    0.00%    100% 100%
5 fri 0    0.00%    100% 100%

6 Totals -10322    -3.15%      97% 100%

Sorry if i get this wrong how do i wright this as formula if more than 2
cells in B have a -% then c6 =d6-b6 if not more than two cells then c6
should read 100%

Reply to this Message

JLatham - 20 Sep 2006 01:01 GMT

In C6:
=IF(COUNTIF(C1:C5,"<0")>2,D6-B6,1)
if C6 is formatted as %, then it will display 100% when there less than 3
negative values in B1:B5.

> a b c
> d
[quoted text clipped - 9 lines]
> cells in B have a -% then c6 =d6-b6 if not more than two cells then c6
> should read 100%

Reply to this Message

highlander_jlp - 20 Sep 2006 02:46 GMT

JLatham thank you this works for me thank you again

> In C6:
> =IF(COUNTIF(C1:C5,"<0")>2,D6-B6,1)
[quoted text clipped - 14 lines]
> > cells in B have a -% then c6 =d6-b6 if not more than two cells then c6
> > should read 100%

Reply to this Message

JLatham - 20 Sep 2006 04:25 GMT

Glad to hear it, and thanks for the thanks! Much appreciated.

> JLatham thank you this works for me thank you again
>
[quoted text clipped - 16 lines]
> > > cells in B have a -% then c6 =d6-b6 if not more than two cells then c6
> > > should read 100%

Reply to this Message