Gaming, IT, Multimedia & Music Please use this forum to discuss Gaming, IT, Multimedia & Music. |
|
10th March 2009, 20:38
|
#1
|
Frequent Poster
Join Date: May 2007
Location: Cradley Heath
Posts: 912
Car(s): Mk 1 VTR
|
Any Excel wizards out there???
Basically need a formula that will leave a cell blank if theres is no data entered in the cell its looking at.
I have an 'IF' statement that works out a simple 'YES' or 'NO' answer, but if the cell is empty which it looks at it leaves 'YES' in the cell. This is my formula:
=IF(J10<1000,"YES","NO")
|
|
|
10th March 2009, 21:41
|
#2
|
Established Member
Join Date: Dec 2008
Location: Hemel Hempstead
Posts: 1,013
Car(s): Citroen Saxo 16v 1.6 VTS '99 (Pearlescent Blue/Red
|
=IF(J10=0,,IF(J10<1000,"YES","NO"))
Will give a 0 in the cell if J10 is blank, though you can enter something between the 2 commas if you want something else to appear there. Its a nested if function.
__________________
IF is a two letter word for futility
|
|
|
The Following User Says Thank You to bpm For This Useful Post:
|
|
11th March 2009, 08:00
|
#3
|
Central South
Join Date: Jun 2006
Location: East Sussex
Posts: 3,105
Car(s): VTS :)
|
=if(j10 <> "", if(j10<1000,"yes","no"),"")
__________________
Can I be your car fwrend??
|
|
|
The Following User Says Thank You to Alex For This Useful Post:
|
|
11th March 2009, 08:33
|
#4
|
Frequent Poster
Join Date: May 2007
Location: Cradley Heath
Posts: 912
Car(s): Mk 1 VTR
|
cheers guys... i'll give them a go later!
|
|
|
11th March 2009, 17:03
|
#5
|
Established Member
Join Date: Sep 2008
Posts: 1,390
|
yeh the blank bit should be made up of the "" bit because between the quotes its blank...
|
|
|
11th March 2009, 20:44
|
#6
|
Frequent Poster
Join Date: May 2007
Location: Cradley Heath
Posts: 912
Car(s): Mk 1 VTR
|
great... the formula works!!! alex i used yours but was wondering could you giv me a brief explanation on how the formula works?
|
|
|
11th March 2009, 21:26
|
#7
|
Frequent Poster
Join Date: Nov 2003
Location: Tayside
Posts: 893
Car(s): S/c VT!?
|
Quote:
Originally Posted by Alex
=if(j10 <> "", if(j10<1000,"yes","no"),"")
|
Quote:
great... the formula works!!! alex i used yours but was wondering could you giv me a brief explanation on how the formula works?
|
Code:
IF
J10 is not equal to ""
IF
J10 is less than 1000, show "yes"
ELSE
show "no"
END IF
ELSE
show ""
END IF
Everything within the "s is classed as text. So "" is blank/no text. "yes" really just shows yes without the "s
|
|
|
12th March 2009, 20:23
|
#8
|
Frequent Poster
Join Date: May 2007
Location: Cradley Heath
Posts: 912
Car(s): Mk 1 VTR
|
Quote:
Originally Posted by gd16
Code:
IF
J10 is not equal to ""
IF
J10 is less than 1000, show "yes"
ELSE
show "no"
END IF
ELSE
show ""
END IF
Everything within the "s is classed as text. So "" is blank/no text. "yes" really just shows yes without the "s
|
fuk man... mind bending or what... just cant get the logic, but thanks anyway! more practice i think :-(
|
|
|
13th March 2009, 07:52
|
#9
|
Central South
Join Date: Jun 2006
Location: East Sussex
Posts: 3,105
Car(s): VTS :)
|
which bit don't you understand?
__________________
Can I be your car fwrend??
|
|
|
13th March 2009, 13:16
|
#10
|
Frequent Poster
Join Date: Nov 2003
Location: Tayside
Posts: 893
Car(s): S/c VT!?
|
Just a nested IF statement. One IF statement inside of another.
Even spaced it out neatly to make it easier to follow.
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT. The time now is 06:55.
|