Formula help

[rhombus4]

I have numbers which are formatted with no decimal places. i.e. 13/4 =3these are in column A, what I need in column B is a formula which is A*5 but will show 15 not 3.25*5 and also format it in time units of 5 minse.g. if A = 3.25 which will show as 3 then column B will show 15 mins shown as 0.15

 

[VoG]

Try

=INT(A1)/20

 

[rhombus4]

Try

=INT(A1)/20

tried to add an if before which works on most, becase I only want it to do the formula if greater than 0

=IF(A5<=0,"",INT(a5)/20) however one of the answers is 0.

It calculates cell d-c which is 12-11.25 which equals 0.75 but when it divides by 20 it shows as 0

 

[VoG]

Try

=IF(INT(A1)=0,"",INT(A1)/20)

 

[rhombus4]

Try

=IF(INT(A1)=0,"",INT(A1)/20)

It worked for some but not others
-1 -0.18 0.46 0.310 0.51 -1 -0.0510 0.4513 0.656 0.3

 

[VoG]

Try

=IF(INT(A1)<1,"",INT(A1)/20)

 

[rhombus4]

Try

=IF(INT(A1)=0,"",INT(A1)/20)

I did change it to =IF(INT(A1)<=0,"",INT(A1)/20)
but one didnt work it was 12-11.25 which shows as 1 but when /20 or multiplied by 0.05 shows as a blank, whereas all the other ones seem to work

 

[rhombus4]

Try

=IF(INT(A1)<1,"",INT(A1)/20)

still shows blank on the 12-11.25 one

 

[VoG]

Perhaps

=IF(A1<0,"",ROUNDUP(A1,0)/20)

 

[rhombus4]

Perhaps

=IF(A1<0,"",ROUNDUP(A1,0)/20)

</p>that works for that on but throws up another one 16-5.75 which is 10 shows as 0.55 instead of 0.50</p></p> Also got an 18-4.75 which is 13 which shows as 0.70. Is there a way if the value is over 0.60 to show as 1.10 as in 1hr 10 not 0.70 </p>