Excel formula - for the Calculation

[Parasa]

Dear Experts ,

I need some help to achieve a formula in Excel , Requesting your help in this

My formula is as below
5238.73/24/214*1000 = 1020.00(Ans)


5238.71 is the value currently comming in one of collum

1020 should come after implementing the formula

24 is the hours

214 is the days (eg Jan to oct-- dynamically increment)

1000 is the fixed value to be multiple


The calculation result should be show in diffrent cell.

Please help me in this

Many Thanks
Purushottam

[Sam Capricci]

just put it in a cell preceded with an equal sign like this =5238.73/24/214*1000

[Parasa]

Thanks for your resonse - but here no of days (214) will be dynamic - in the sense it can now 214 .. after 11 days it will 230 then automatically the days should be changed.

Many Thanks
Purushottam

[Sam Capricci]

Well you can swap out that part for a cell reference like =5238.73/24/ B2*1000 for example.

[Parasa]

Hi Sambo

Thanks for your response and time

Days were colloum is not there in the report.

we need to pick those days dynamically. (APRL 30 days ,May 31 ,June 30 ,July 31 Days....like that March) all days it has to pick dynamically.

Many Thanks
Parasa Purushottam
09986195904

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)