=IF(E12="","",IF(E12<=0.79,0,IF(E12<=0.99,10,100)) )

"GinnyJ" wrote:

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