Range of variables with the 'floor' command included
 

Hi,

I've never used Excel for anything like this and wasn't sure what to search
for to see if it's been discussed. I'm also not sure if Excel can do it.
This is what I need.

In MathCAD, I have it laid out as such:

n:= 1..floor(Wh) (Wh being defined earlier)
r(sub n):= r(sub n-1) + Hd (Hd being defined earlier)

Thanks in advance.