Avoiding the #Div/0! error message in a formula?

[Wilgoss]

hi - I need to get the result of a sum which may have 0.00 as a value in its dependents

I want to allow people to choose how they propose a pay increase, by percentage or £ and then use a formula based on the maximum value between the two but at the same time allow the user to post the inevitable 0.00% and £0.00 at the same time (i.e. no salary increase)

But when I try to use 0.00 values in a formula I'm getting the DIV/0! error!

Example attached!

Thanks in advanceBook14.xlsx