View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GEM GEM is offline
external usenet poster
 
Posts: 90
Default Inserting Symbols with IF Function.

On column A, I have numbers running down to row 100. I want to add an IF
function on column B which inserts an arrow () next to the highest number
from column A. It dosen't matter if the highest number on column A is
repeated as long as the arrow () is inserted everytime the highest number
appears.

Another question is if this can be done if I used the "&" on column A. For
example, A1=D1+C1&" - "&E1+F1. I want to know which is the highest number
from column A, but from the second string, that is E1+F1.