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.

If statement
Fenix internet on bank statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel if statement - Guide
Sbi bank statement - Guide
Excel if statement contains multiple words ✓ - Excel Forum

2 responses

Answer 1 / 2

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

Answer 2 / 2

Trowa
Oct 8, 2009 at 07:26 AM

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

Similar discussions

Removing " false" value in "IF"

Removing "FALSE" from an IF statement with a VLOOKUP

removing false in excel

Removing False Value

Need help to remove FALSE from cell

Similar discussions

Subscribe To Our Newsletter!