What I'm trying to do:
Thank you in advance.
- I have a Cell that has a Number in it.
- I have a Cell that has a Formula in it.
- I'd like to have the Number Cell (Cell #1) be Greater Than and override/default from the Formula Cell (Cell #2) when applicable (otherwise it defaults to the higher value of the two).
- I'd like it to return/total a Number.
- Here's what I have: =IF(I8>(D8*I5)+J5,"I8")
- Note:
- I8, J5, and J8 are Formula Cells.
- D8 is a Number Cell.
Thank you in advance.