If Function Help

D

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
 
R

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
 
Top