Formula HELP!

  • Thread starter Thread starter hEE Hee
  • Start date Start date
H

hEE Hee

HI All
I am trapped in IF statement. I was wondering if you'd help me out.
I am making a sheet with 3 T accounts.
ie
A B C D E
Returns £1,237.00 £975.00 £1,237.00 £975.00

I need formulas in cell D & E to find out if any of the figure is > then
each other it should substruct the smaller figure from the greater
figure (itself).
In short I am looking for an answer 262 in D. and 0 in E and also to be
able to work out if the figures were other way round in B & C eg £975 in
B and £1237 in C hence D=0, E=262

I think I have explained it OK

thanks
 
thanks frank

| Hi
| one way:
| In D1 enter
| =IF(C1>B1,0,B1-C1)
|
| in E1 enter
| =IF(C1<B1,0,C1-B1)
|
| HTH
| Frank
|
| hEE Hee wrote:
| > HI All
| > I am trapped in IF statement. I was wondering if you'd help me out.
| > I am making a sheet with 3 T accounts.
| > ie
| > A B C D E
| > Returns £1,237.00 £975.00 £1,237.00 £975.00
| >
| > I need formulas in cell D & E to find out if any of the figure is >
| > then each other it should substruct the smaller figure from the
| > greater figure (itself).
| > In short I am looking for an answer 262 in D. and 0 in E and also to
| > be able to work out if the figures were other way round in B & C eg
| > £975 in B and £1237 in C hence D=0, E=262
| >
| > I think I have explained it OK
| >
| > thanks
|
|
 
Back
Top