if G>I i want A seleceted if I>G than i want C selected

[Guest]

How do I do a formula to select a certain cell. If G>H I want the program to
select cell A. If H>G than I want the program to select cell C. How do I
program this. What tool do I use.

thanks
Mike

 

[Bob Phillips]

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

--

HTH

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

 

[Frank Kabel]

Hi
with activesheet
if .range("H1").value<.range("G1").value then
msgbox .range("a1").value
elseif .range("H1").value>.range("G1").value then
msgbox .range("c1").value
else 'equal
msgbox "not defined"
end if
end with

 

[Guest]

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

--

HTH

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





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

thanks
mike

 

[Guest]

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

--

HTH

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





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

thanks
Mike