nested formula using IF & AND
I would like to know if it is possible to make a nested formula with IF & AND with the following logic:
If the difference between two dates is negative (column “I”) give me 0; otherwise if the difference is positive (column “j”) and the range of cell is = to OPEX then do the calculation (OPEX/365*nr.of days)
You can see the attached file as example. (the yellow cells are the one that formula is not correct, I want 0 value because number of days is negative.
Thanks
|