# Excel Formula required

#### amdm888

##### New Member
Hi,

I am working on a Spreadsheet but I need help.

I will be working on 3 or even 4 figure numbers mainly and they will be whole or fraction numbers, it just depends on numbers according to the count in a bit of research I am doing. So the figures could be 4215 or 9934
9923.42 or even 3350.81 etc....

I just want this to be done as it is part of a research my brother was doing but as he is no longer here, I cannot ask him how it is done. He has passed away.

Are you able to construct something like this for me...?

I will be grateful if you can.

regards...
Andrew

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

#### BJungheim

##### Well-known Member
Formulas:

C1 - =A1/A2
C2 - =A2/A1
D1 - =B1/B2
D2 - =B2/B1
E1 - =CEILING(MAX(D1:D2),1)
E2 - =CEILING(MAX(D1:D2),1)
F1 - =E1-D1
F2 - =E2-D2
G1 - =C1+F1
G2 - =C2+F2
H1 - =IF(MAX(G1:G2)<>G1,"",G1-G2)
H2 - =IF(MAX(G1:G2)<>G2,"",G2-G1)

There are other ways to do this but I believe this should get you started.

#### amdm888

##### New Member
Hi BJungheim,

Thanks for taking the time out and solving it - I appreciate it and also for being very quick.
I will now go and try it and report back.

regards...
Andrew

#### amdm888

##### New Member
Thanks

Hi BJungheim,

Just tried it proper and can I just say that it works fine and I am very happy.
Thank You for all your help.

regards...
Andrew

Replies
0
Views
93
Replies
9
Views
158
Replies
3
Views
394
Replies
11
Views
192
Replies
5
Views
69