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
Application for bank statement sbi - Guide
Excel if statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Vba case statement - Guide

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"

Need help to remove FALSE from cell

removing false in excel

Removing "FALSE" from an IF statement with a VLOOKUP

Removing False Value

Similar discussions

Subscribe To Our Newsletter!