Calculating
I need a formula that can calculate the following:
If month($B$2) equal month (D10) the maximum it can calculate to is 1, otherwise add D11+D12-D13 The formula is in D14. So one month that correspond with B2 is going to have a value of 1 or less when you add row 11and 12 then minus13. while the other will have the right result. |
Calculating
hi
i might be a tad slow but.. If month($B$2) equal month (D10) the maximum it can calculate to is 1, otherwise add D11+D12-D13 assuming that B2 and D10 are real dates.... =if(month($B$2)=Month(D10),1 ,sum(D11+D12-D13)) or did i miss something? or did you leave out something? regards FSt1 "Link" wrote: I need a formula that can calculate the following: If month($B$2) equal month (D10) the maximum it can calculate to is 1, otherwise add D11+D12-D13 The formula is in D14. So one month that correspond with B2 is going to have a value of 1 or less when you add row 11and 12 then minus13. while the other will have the right result. |
Calculating
"Link" wrote:
I need a formula that can calculate the following: If month($B$2) equal month (D10) the maximum it can calculate to is 1, otherwise add D11+D12-D13 The formula is in D14. So one month that correspond with B2 is going to have a value of 1 or less when you add row 11and 12 then minus13. while the other will have the right result. I do not understand your description. But by any chance, is the following what you want: =if(month($B$2)=month(D10), min(1,D11+D12-D13), D11+D12-D13) |
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com