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