Formula needed to determine higher figure and subtract lower

[nails]

Hi.. I'm an excel newbie and so would be grateful for any help with my question;

f i k

100 50
100 150

I want to get an answer for to display in k. I need to start with col f as that is my base fig. Sometimes the figure in i is lower than f and sometimes it's higher so I need a calculation that determines which is the higher figure f or i and then subtracts the lower figure and displays it in k.
I do not want a negative figure. Does this make sense?

Chris.

 

[yogeshmaney]

=if((F1-I1)<0,(F1-I1),(I1-F1))

 

[yogeshmaney]

rather
=if((F1-I1)>0,(F1-I1),(I1-F1))

 

[j_latendre]

Try

=MAX(F1,K1)-MIN(F1,K1)

Jesse

 

[nails]

When i try this i get:

You have entered too many arguments for this function

 

[yogeshmaney]

close brackets

 

[nails]

Hi Jesse

When I try this I get a result of 0 which is wrong as the figures are:

f 7500 i 6366.72

 

[GlennUK]

Surely, it's all simpler than that:

=ABS(F1-I1)

 

[j_latendre]

My apologies, I put the wrong letter in :S

=MAX(F1,I1)-MIN(F1,I1)

Jesse

 

[nails]

Surely, it's all simpler than that:

=ABS(F1-I1)

Thanks Glenn that works a treat.. Thanks to all for your help.