Formula Help

[sosteffo]

Need to to calculate the following

Cell A1 had a figure calculated .....example 174

I then need a formula below in B1 to calc multiples of 97 and retur
the figure that is greater than 174

i.e 174 in A1
194 in B1 (97*2)
20 in C1 (difference

 

[Peo Sjoblom]

B1

=97*2

C1

=B1-A1

 

[sosteffo]

Thanks but its not that simple........the figure of 174 will be an eve
changing figure...therfore the 2*97 will need to automatically chang
so that its result is greater than the first figure..

Figure in B1 will need to be >A1 & a multiple of 97


I've tried lots of ways......not simple way it appear

 

[Rutgers_Excels]

A1 = 174 (calculated value)

B1 =ROUNDUP(A1/97,0)*97

C1 =B1-A

 

[sosteffo]

thanks i work it out another way

i did = (INT(A1)+1)*97

it works anyways...thanks for the suggestion tho