IF Function

**ahmedmido** · 03-11-2010, 06:13 AM

Hi
I'm using IF function with two arguments but when the cell is empty it still shows value

How to stop showing value when the cell is blank

Thanks

Ex is attached

**zbor** · 03-11-2010, 06:25 AM

Here, try this:

=IF(A1="","",IF(A1<=2,"OK","WRONG"))

**zbor** · 03-11-2010, 06:28 AM

Also check Syntax of the IF function:

=IF(logical_test, value_if_true, [value_if_false])
=IF(A1<=2,"OK","WRONG")

So.. IF A1 <= 2 is TRUE then anything else, (wich is A1>2) is FALSE.
No need to check is A1 bigger than 2 (again)...

**ahmedmido** · 03-11-2010, 06:34 AM

Thanks Alot it works

Thread: IF Function

Thread Tools

Display

IF Function

Re: IF Function

Re: IF Function

Re: IF Function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions