# Excel Question

steviegee 09:44 22 Jun 07
Locked

I have a cost in cell A1 of 2.30, in cell B1 2.50, in cell C1 2.70, in cell D1 3.00, in cell E1 3.50. Is there a formula which will give me the % of how much more the cells are to A1 in other cells.

So in F1 in need to know the % of how much more B1 is to A1, G1 I need to know the % of how much more C1 is to A1 etc.

I hope I have explained it as simply as I can!!!

VoG II 09:52 22 Jun 07

In F1

=100*(B1-\$A1)/\$A1

and copy the formula across as far as I1.

steviegee 10:12 22 Jun 07

That works good thanks now the next thing!! How do I keep the formulas in the cells but have the cells blank so I can type in different amounts. So I can enter amounts in A1-E1 and the % gets automatically entered in F1-K1!?

VoG II 10:19 22 Jun 07

I'm not quite sure what you mean. Perhaps:

=IF(OR(ISBLANK(\$A1),ISBLANK(B1)),"",100*(B1-\$A1)/\$A1)

in F1 and copied across.

steviegee 10:33 22 Jun 07

Thanks that has worked perfectly. Thanks again VoG.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5