Eawyne
New Member
- Joined
- Jun 28, 2021
- Messages
- 44
- Office Version
- 2013
- Platform
- Windows
Hi all ?
so I have this formula in cell I27 :
The values in cells H25 and K25 need to be entered manually by the user ; so cell I27 of course updates each time one cell is filled, but the result isn't correct until both are. I've tried figuring out a formula to have cell I27 only showing a result when both cells are containing data, but I haven't been able to do so. I've tried with IF, IFCOUNT, IFCOUNTS... the thing is that I don't have a proper grasp of simple formulas (which I'm trying to sort out as well - by the way, if anyone had some links to understand how to use ; : , properly with cells ?) so I'm struggling to come up with a solution.
Thanks for any help you may provide !
so I have this formula in cell I27 :
Excel Formula:
=IFERROR((H25-K25)/H25*100;0)
The values in cells H25 and K25 need to be entered manually by the user ; so cell I27 of course updates each time one cell is filled, but the result isn't correct until both are. I've tried figuring out a formula to have cell I27 only showing a result when both cells are containing data, but I haven't been able to do so. I've tried with IF, IFCOUNT, IFCOUNTS... the thing is that I don't have a proper grasp of simple formulas (which I'm trying to sort out as well - by the way, if anyone had some links to understand how to use ; : , properly with cells ?) so I'm struggling to come up with a solution.
Thanks for any help you may provide !