Excel Formula required

[amdm888]

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.

Thanks for your help in advance......

regards...
Andrew

 

[BJungheim]

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]

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]

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