Articles

nested if condition in excel

November 18, 2010 at 21:34:20
Specs: Windows XP

while checking the value the condition comes like this

if certain cell contains no value (what symbol or command has to be used to specify that cell contain nothing) then insert the value contained in
another cell. how to specify this in nested if statement


See More: nested if condition in excel

Report •


#1
November 19, 2010 at 05:12:37

This doesn't sound like a Nested IF, it sounds like a basic IF function.

You also didn't tell us what to return if the "certain cell" isn't empty

Let's assume your "certain cell" is A1. Try this:

=IF(A1="", B1, "The cell isn't empty")

A Nested IF would contain another IF:

=IF(A1="", B1, IF(A1>100, C1, A1))

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question