Calculating

  • Thread starter Thread starter Link
  • Start date Start date
L

Link

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.
 
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
Click to expand...
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 said:
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.
Click to expand...

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)
 
Back
Top