If statement

Closed
gracious - Oct 6, 2009 at 02:36 PM
 Trowa - Oct 8, 2009 at 07:26 AM
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.

2 responses

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Oct 6, 2009 at 02:54 PM
works for me, what version of excel are you using and what errors are you getting
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