ExcelBanter - Adding to an exsisting formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding to an exsisting formula (https://www.excelbanter.com/excel-discussion-misc-queries/110624-adding-exsisting-formula.html)

Holsapple

Adding to an exsisting formula

I need to know if or how I can add to an exsisting formula. I have currently
=SUMA1+B1 I need to add
=INT(A1)+ROUND(MOD(A1,1)*100/60,2)

Dave F

Adding to an exsisting formula

Can't you just do =INT(A1)+ROUND(MOD(A1,1)*100/60,2)+B1?

Dave
--
Brevity is the soul of wit.

"Holsapple" wrote:

I need to know if or how I can add to an exsisting formula. I have currently
=SUMA1+B1 I need to add
=INT(A1)+ROUND(MOD(A1,1)*100/60,2)

[email protected]

Adding to an exsisting formula

So do you want it to look like this?
=Sum((INT(A1)+ROUND(MOD(A1,1)*100/60,2))+B1)
or what?

Holsapple wrote:
I need to know if or how I can add to an exsisting formula. I have currently
=SUMA1+B1 I need to add
=INT(A1)+ROUND(MOD(A1,1)*100/60,2)

All times are GMT +1. The time now is 12:32 AM.