View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zhang zhang is offline
external usenet poster
 
Posts: 6
Default How do I make a function for < and

select B1 Then write
=if(A1<20,"High",if(a1<26,"Within Margin",if(a126,"Low","N/A")))


"SeeStation" ...
Cell a1 contains the result of a function (19.94)

how can I make a function for B1
b1="High" if a1 is <20
b1="Low" if a1 is 26
b1="Within Margin" if 26<a120
b1="N/A" if false or if a1 contains "#VALUE" as a result of it's function
not being fullfilled?

Thanks!