Formula Help

S

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
 
S

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
 
S

sosteffo

thanks i work it out another way

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

it works anyways...thanks for the suggestion tho
 
Top