View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GinnyJ GinnyJ is offline
external usenet poster
 
Posts: 4
Default need a formula for this scenario

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