View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
sciacqua1 sciacqua1 is offline
external usenet poster
 
Posts: 4
Default if GI i want A seleceted if IG than i want C selected



"Bob Phillips" wrote:

=IF(G1H1,A1,IF(G1<H1,C1,""))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"sciacqua1" wrote in message
...
How do I do a formula to select a certain cell. If GH I want the program

to
select cell A. If HG than I want the program to select cell C. How do I
program this. What tool do I use.

thanks
Mike



I;ll give it a try and see how it works.


thanks
mike