LinkBack URL
About LinkBacks
How do you write an if statement that will run if the cell is not blank.
if cell a3 is not blank or contains (letters) then divide by 3 if it is blank divide by 2
thank you !!
Blank if statements
How do you write an if statement that will run if the cell is not blank.
if cell a3 is not blank or contains (letters) then divide by 3 if it is blank divide by 2
thank you !!
=IF(cell="",true,false)
=if(a3<>"",a3/3,a3/2)
Can you expain exactly what you need to do, only if A3 contains letters you will get an error if you divide by 3, also if it's blank, whats the point in dividing it by 2?Originally Posted by cjohnsen
How do you write an if statement that will run if the cell is not blank.
if cell a3 is not blank or contains (letters) then divide by 3 if it is blank divide by 2
thank you !!
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks