View Single Post
  #1   Report Post  
kate nz
 
Posts: n/a
Default choosing a cell with a comment

I need a formula that will allow me to display different text values based on
a sum of 2 cells from another worksheet depending on the value of the sum....

if the sum of the 2 cells is =0.3 & <=0.49 then I need to display a comment
stored in cell F22 from another worksheet. If sum is <=0.5 I need comment
from cell F23. If the sum is<0.3 then I need the cell to remain blank.