Thread: Round Down
View Single Post
  #1   Report Post  
Quilp Quilp is offline
Junior Member
 
Posts: 27
Default Round Down

I have this formula in cell X73: =IF(A73="","",U73-(C73*2.433)) which returns the value 39.58.
In cell Y73 I have this formula: =ROUNDDOWN(X73,0) which returns the value 39.
Is there any way that I can combine these formula's into cell X73 so that I do not have to have column Y?
I have tried inserting + between the two and also tried AND but neither works. I am actually using Planmaker for this spread sheet but it is almost the same as Excel, or so I am told.
I should mention that I am a 79 year old spread sheet newbie so please be gentle with me!