If statement Closed

Question

Hello,
  If  (N2) >0, then cell value will equal L2, otherwise it will be N2 or =SUM(N2*0.04)+((L2*0.96))

how to put that into a formula  I keep getting errors  so I an missing the boat how to get his one written.

sharpman · Answer

works for me, what version of excel are you using and what errors are you getting

Trowa · Answer

Hi gracious,

You are giving two statements for the condition being false.
So your formula can either be:

=IF(N2>0,L2,N2)
or
=IF(N2>0,L2,(N2*0.04)+(L2*0.96))

You could also add another condition.

If this doesn't help you, be more clearly about your query.

Best regards,
Trowa

If statement

2 responses

Similar discussions

Subscribe To Our Newsletter!