If Function Help

[Duncan, UK]

I am trying to create a function that relates to whether a cell is higher or
lower than a value.
What I want is if G123<5000 then the cell shows the content of B10, but if
G123>4999 then the cell shows the content of A124.
I can do the first bit eg =if(g123<5000,B10) but cannot add the second
argument.
Any ideas please?
Regards
Duncan

[robert111]

all if statements require 2 parts, the true and the false

if(a1<10,a2,a3)

so if a1 is 9 or less it returns a2, but if 10 or more it returns a3

[Duncan, UK]

Great thanks, that works

Duncan

"robert111" wrote:

>
> all if statements require 2 parts, the true and the false
>
> if(a1<10,a2,a3)
>
> so if a1 is 9 or less it returns a2, but if 10 or more it returns
> a3
>
>
> --
> robert111
> ------------------------------------------------------------------------
> robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
> View this thread: http://www.excelforum.com/showthread...hreadid=554899
>
>