Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if GI i want A seleceted if IG than i want C selected
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
if GI i want A seleceted if IG than i want C selected
=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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
if GI i want A seleceted if IG than i want C selected
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 -- Regards Frank Kabel Frankfurt, Germany sciacqua1 wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple cells or columns are selected instead of selected cell or | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Discussion (Misc queries) | |||
Cells are selected but aren't displayed as selected | Excel Worksheet Functions | |||
A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
how do i make it so that when a sheat is selected either via link or tab, that xlLastCell is selected. the last on the sheet. | Excel Worksheet Functions |