Excel Formula required

amdm888

New Member
Joined
Dec 12, 2005
Messages
5
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
 

Some videos you may like

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
Joined
Jul 24, 2004
Messages
914
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
Joined
Dec 12, 2005
Messages
5
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
Joined
Dec 12, 2005
Messages
5
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,680
Members
412,481
Latest member
nhantam
Top