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
G1234999 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

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

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