I need help with some formulas in Access.
1. Here's the formula I use in Excel to calculate the end date: =IF(C25=0," ",(C20+(C25*7))-1). I need a formula like this in Access to calculate the end date. I have a start date column and PPD weeks column. I need to calculate the end date with the start date column + PPD weeks column.
2. Here's the formula I use in Excel to calculate TTD Rate: =IF(B61*2/3>617,617, B61*2/3). I need a formula like this in Access. I need the calculated number to be rounded, too. I also need to add a condition that if DOI column is 01/01/14 use 617, if DOI column is 01/01/13 use 602, if DOI column is 01/01/12 use 584, if DOI column is 01/01/11 use 575, if DOI column is 01/01/10 use 562, if DOI column is 01/01/09 use 550.
3. Here's the formula I use in Excel to calculate PPD Rate: =IF(E62>205.34,IF((0.75*E62)<463,ROUND(0.75*E62, 0),463), IF(2/3*B61<154, ROUND(2/3*B61, 0), 154)). I need a formula like this in Access. I also need to add a condition that if DOI column is 01/01/14 use 463, if DOI column is 01/01/13 use 452, if DOI column is 01/01/12 use 438, if DOI column is 01/01/11 use 431, if DOI column is 01/01/10 use 422, if DOI column is 01/01/09 use 413.
4. I need a formula that takes the TTD Rate column (which is a weekly rate) x ttdweeks column x ttddays column = Total TTD paid.
Thanks for your help.
Jeremy
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (21) |
Tidak ada komentar:
Posting Komentar