Need help with formula to give 0 if value is negative or answer is

S

Sharona77

I have a lengthy formula calculating salary raise for a year, and need to tie
it into how long the project goes (in months). I have three cells set up with
the formulas, each for a different time frame that I may use, and I have a
cell that has the actual duration in months for each project (E16 would be
17months). I can do 'sum from formula'/12*(E16-12) to get the # of months
over a year for year 2 (5 months), but anything over that I get a negative
number, and I want it be from 25-36 months, then 37-48, etc. I want E16 to
trigger the correct cell to fill based upon its number, and put "0" in the
ones that don't apply. The formula was too long for an IF statement when I
tried it. Ideas?

S
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rolling 12 month 9
need help with Formula 1
Age Formula 15
help with Sum in between dates 12
Depreciation Spreadsheet 3
Help With Formula For Cell Addresses 2
If Formula and Dates 4
Multiple IF statment help 7

Top