need a formula for this scenario
WAHOO!! this helped me to get it to work - Thanks so much
"PCLIVE" wrote:
I didn't seen in your formula that states what the value should be if the %
is between 50 and 80.
The formula below assumes that:
From 0% to 49% returns blank.
From 50% to 79% returns 5.
From 80% to 99% returns 10.
100% returns 20.
=IF(E90=100%,20,IF(AND(E90<100%,E9079%),10,IF(AND (E9049%,E90<80%),5,IF(AND(E90=0%,E90<50%),""))))
"PCLIVE" wrote in message
...
What is the value in E12?
"GinnyJ" wrote in message
...
This gave me a "FALSE" answer in the cell instead of returning the
desired
numbers, i.ei. "20" "20" or "0"
"PCLIVE" wrote:
If I understand what you are trying to do with this formula, try this:
=IF(E12=100%,20,IF(AND(E12<100%,E1279%),"10",IF(A ND(E12=0%,E12<50%),"")))
"GinnyJ" wrote in message
...
in F12 want these to print
IF(E12=100%,"20",IF(E12=<99%,79%,"10",IF(E12=<0%, 50%,"0")))
but don't want 0's to show if blank (before any info filled in)
am having problems with the greater/lesser than portion, also can't
add up
the totals of the F12:F15 because Excell says won't add if cells are a
result
of an argument - how do I get them to total
|