Thread: if GI i want A seleceted if IG than i want C selected
View Single Post
  #5   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


Thanks Bob, That was what I was looking for. Gotta keep track of all the bowl games and point spread winners.

thanks
Mike
Reply With QuoteReply With Quote