| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula
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% |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula
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. "highlander_jlp" wrote: 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% |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula
JLatham thank you this works for me thank you again
"JLatham" wrote: 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. "highlander_jlp" wrote: 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% |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula
Glad to hear it, and thanks for the thanks! Much appreciated.
"highlander_jlp" wrote: JLatham thank you this works for me thank you again "JLatham" wrote: 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. "highlander_jlp" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
