Nested IF function error "You've entered too many arguments for this function"

Screenshot 2021-01-06 224647.jpg
Please see the attached screenshot,
I am trying to calculate the pH of a titration between weak acid and strong base, but when i put =IF(A11=0,-LOG(SQRT($B$4*$D$4)),IF(D11>0,$B$3+LOG($C11/$D11)),IF($B$4*$D$3=$B$5*$A11,14-LOG(SQRT($B$4*$D$4)),14+LOG(($B$5*$A11-$B$4*$D$3)/B11))) function to calculate the pH of them i get "You've entered too many arguments for this function" error.

Vb is the volume of base, Vt is the total volume of the solution, concentration of acid and base both are 0.1 mol dm^-3 each. and acid voulume is 25 mL


This is the solved problem professor sent
Screenshot 2021-01-06 225535.jpg

=IF(A11=0,
-LOG(SQRT($B$4*$D$4)),

IF(D11>0,
$B$3+LOG($C11/$D11))
Theres 2 brackets - only need 1
$B$3+LOG($C11/$D11)

,IF($B$4*$D$3=$B$5*$A11,
14-LOG(SQRT($B$4*$D$4)),
14+LOG(($B$5*$A11-$B$4*$D$3)/B11)
))
probably need another ) at the end

SO
=IF(A11=0,-LOG(SQRT($B$4*$D$4)),IF(D11>0,$B$3+LOG($C11/$D11),IF($B$4*$D$3=$B$5*$A11,14-LOG(SQRT($B$4*$D$4)),14+LOG(($B$5*$A11-$B$4*$D$3)/B11))))

Maybe, untested:

Formula:

Please Login or Register  to view this content.

you are welcome