All you need to do is put the different calcs where you have the text. For example....This is the formula I have to start with, but unsure where to go from here. I don't need it to say Increase, Decrease, or No Change, I just need it to do the calculation needed.
=IF(C12>B12,"Increase",IF(C12<B12,"Decrease","No Change"))
This is the formula I have to start with, but unsure where to go from here. I don't need it to say Increase, Decrease, or No Change, I just need it to do the calculation needed.
=IF(C12>B12,10*10,IF(C12<B12,10*5,5*5))
Not sure what your "special commands" are though?
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
Bookmarks