|
Replies: 15
| visibility 444
|
Heisman Winner [137862]
TigerPulse: 100%
Posts: 63784
Joined: 10/22/00
|
ExcelNet
Nov 5, 2018, 12:18 PM
|
|
Tell me how to make this work:
=if(A5>0,"John Smith","")
This works, returns John Smith.
=if(A5>0,"John Smith","")+if(B5>0,"Bill Cockbreath","")
This no work, and it's some dumb reference I'm missing. I don't think I want to make anything into text...what's the obvious thing I'm missing to return "John Smith Bill Cockbreath" instead of an error?
|
|
|
|
 |
Oculus Spirit [85298]
TigerPulse: 100%
Posts: 24912
Joined: 5/21/14
|
&
Nov 5, 2018, 12:22 PM
|
|
=if(A5>0,"John Smith","")&if(B5>0," Bill Cockbreath","")
Might want to add a space before Mr. Cockbreath
|
|
|
|
|
|
Oculus Spirit [85298]
TigerPulse: 100%
Posts: 24912
Joined: 5/21/14
|
&
Nov 5, 2018, 12:22 PM
|
|
=if(A5>0,"John Smith","")&if(B5>0," Bill Cockbreath","")
Might want to add a space before Mr. Cockbreath
|
|
|
|
|
|
Oculus Spirit [85298]
TigerPulse: 100%
Posts: 24912
Joined: 5/21/14
|
and sign
Nov 5, 2018, 12:22 PM
|
|
=if(A5>0,"John Smith","")&if(B5>0," Bill Cockbreath","")
Might want to add a space before Mr. Cockbreath
|
|
|
|
|
|
Oculus Spirit [85298]
TigerPulse: 100%
Posts: 24912
Joined: 5/21/14
|
Also, if you'd like to cause errors on tnet for which stuff
Nov 5, 2018, 12:23 PM
|
|
can not be loaded from the database. - use & in the subject
|
|
|
|
|
|
Heisman Winner [137862]
TigerPulse: 100%
Posts: 63784
Joined: 10/22/00
|
Nailed it. I knew it was something obvious,
Nov 5, 2018, 12:25 PM
[ in reply to and sign ] |
|
but also, I'm dum.
|
|
|
|
|
|
Oculus Spirit [85298]
TigerPulse: 100%
Posts: 24912
Joined: 5/21/14
|
wuz
Nov 5, 2018, 12:27 PM
|
|
u wuz dum
won't to up your game, use concatenate
=concatenate(if(A5>0,"John Smith",""),if(B5>0," Bill Cockbreath",""))
|
|
|
|
|
|
Heisman Winner [137862]
TigerPulse: 100%
Posts: 63784
Joined: 10/22/00
|
I actually tried concatenate, but it didn't work
Nov 5, 2018, 12:33 PM
|
|
because I'm dum.
|
|
|
|
|
|
Lot o points [155796]
TigerPulse: 100%
Posts: 65777
Joined: 5/6/13
|
It's simple, really.
Nov 5, 2018, 12:24 PM
|
|
Go in your bathroom and disrobe. While standing, place your head between your legs, and look up.
There you go.
|
|
|
|
|
|
Oculus Spirit [79183]
TigerPulse: 100%
Posts: 24915
Joined: 8/29/12
|
THIS
Nov 5, 2018, 12:32 PM
|
|
Obed playing chess while you playin checkers.
Obed, you need to take this kind of pro-tip to the
PROZONE
R
O
Z
O
N
E
|
|
|
|
|
|
Heisman Winner [137862]
TigerPulse: 100%
Posts: 63784
Joined: 10/22/00
|
The "&" seems to work better than the asterisk.
Nov 5, 2018, 12:56 PM
[ in reply to It's simple, really. ] |
|
|
|
|
|
|
|
CU Medallion [50635]
TigerPulse: 100%
Posts: 43019
Joined: 12/3/98
|
7***
Nov 5, 2018, 12:25 PM
|
|
|
|
|
|
|
|
CU Medallion [53231]
TigerPulse: 100%
Posts: 21819
Joined: 11/16/05
|
Re: Prerequisites met?
Nov 5, 2018, 12:29 PM
|
|
Milk in the freezer yet?
Cut a hole in the box?
|
|
|
|
|
|
Oculus Spirit [79183]
TigerPulse: 100%
Posts: 24915
Joined: 8/29/12
|
If'n you don't like usin them fancy formulas, u know u kin
Nov 5, 2018, 12:30 PM
|
|
always filter by ranges on a column. So if you're looking for all values in column A greater than zero, just click the down arrow on the filter and select "Number Filters". Then filter on column B for greater than 0 to get Sir Cockbreaths results.
|
|
|
|
|
|
CU Medallion [54758]
TigerPulse: 100%
Posts: 52802
Joined: 10/1/03
|
wait, so you WANT Cockbreath?
Nov 5, 2018, 12:32 PM
|
|
because I can think of better ways, ways that are more, um....mutually beneficial.
|
|
|
|
|
|
Oculus Spirit [81889]
TigerPulse: 100%
Posts: 47113
Joined: 3/18/07
|
=concatenate(if statement,if statement, more stuff)***
Nov 5, 2018, 12:50 PM
|
|
|
|
|
|
|
|
Replies: 15
| visibility 444
|
|
|
50
