formula placement

**sdts** · 07-02-2011, 01:16 AM

hi guys i am absolutely useless with formulas and wondered if someone would be kind enough to help.

ok here goes

if c 20 is greater than 7000 i need a cell to work out the difference

so for example if c20 is 7224 in the cell h20 it will return the value 224

**sdts** · 07-02-2011, 02:19 AM

please delete this thread

**royUK** · 07-02-2011, 02:30 AM

Why? If you've got a solution then share it

**sdts** · 07-02-2011, 03:26 AM

hi roy

i hadnt properly worked out what i was trying to do
i had another reference i could off set it to and it was a simple case of subtracting from another cell