Iferror rounddown help

[annep833]

Hello, I want to rounddown the value in r2, add that value to the value in s2, and divide the total of those 2 values by the value in T2 without the div error. I am using 2010 excel. Thank you!

 

[annep833]

Also the rounddown is to a whole number (0)

 

[Fluff]

How about
=IF(OR(T2={"",0}),"",(ROUNDDOWN(R2,0)+S2)/T2)

 

[annep833]

That's not working. I'm sorry. Maybe this would be better... using a macro to divide the value entered in column S by 4 then rounddown that value to a whole number. Then I could use a simple iferror function to calculate the value for column v.

 

[Joe4]

I think maybe your description isn't quite clear, if Fluff's formula didn't work for you.
Can you walk us through an actual example, showing us exactly what value you arrrive at and how?
BTW, a macro should be totally unnecessary for any of this. Excel's built-in functions should be able to handle it, so I don't see any advantage to using VBA here.

 

[Fluff]

As well as what Joe has said, can you please use the XL2BB add-in to post some sample data, along with expected results.