Syntax with "IF" statement...
- From: garry05 <garry05.1zoc8b_1133966101.454@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 7 Dec 2005 08:32:32 -0600
Trying to resolve a situation that I've got posted elsewhere on here;
maybe I can do it this way if someone can help me with the syntax for
using "IF".
Say that column G is numbered 1-5, and column H has values of 100, 133,
322, 440, 560.
I'll enter a number (1-5) in col A, and I want this to happen in col B,
and I'll express it in human language: If A2=3 then B2=322...If A1=5
then B1=560.
In other words, I post a number in A, then go search G for the same
number, then post the corresponding H value into B.
I've tried the syntax every way but the right way, I guess.
Thanks,
Garry
--
garry05
------------------------------------------------------------------------
garry05's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29408
View this thread: http://www.excelforum.com/showthread.php?threadid=491451
.
- Follow-Ups:
- Re: Syntax with "IF" statement...
- From: skaggsj@xxxxxxxxx
- Re: Syntax with "IF" statement...
- Prev by Date: Sorting Function
- Next by Date: Re: How do I display a ControlTip for a disabled control
- Previous by thread: Sorting Function
- Next by thread: Re: Syntax with "IF" statement...
- Index(es):
Relevant Pages
|
