[Excel] arguments, functions and #Div/0!

[Eawyne]

Hi all ?

so I have this formula in cell I27 :

=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 !

 

[RoryA]

You could use:

=IF(COUNT(H25;K25)=2;IFERROR((H25-K25)/H25*100;0);"")

 

[Eawyne]

Holy cannoli, it works ! I completely understand your solution, but I would never've found it on my own I believe. Thanks a lot.

 

[RoryA]

Glad we could help.