General Betting
There is currently 1 person viewing this thread.
06 Feb 10
06:49
Joined:
Date Joined:
08 Aug 08
Just getting my spread sheets ready for the flat, am self taught so need some help that may seen obvious to some.
if cell p18 is Q A, I want cell q18 to have the number 40 in it.
Also, if cell p18 is S A cell q18 to be -20
tia
GGR
if cell p18 is Q A, I want cell q18 to have the number 40 in it.
Also, if cell p18 is S A cell q18 to be -20
tia
GGR
sort by:
Show
per page
Replies: 18
|
By:
=IF(p18="qa",40,(IF(p18="sa",20,0)))
The format for If is query, return if true, return if false. In this instance, it checks to see if p18 is "qa" , if so it returns 40 if not, it checks again to see if it's "sa", if so it returns 20, if not it returns 0 If the only options are qa and sa, you could simplify to =IF(A2="qa",40,20) |
|
By:
I seem to remember Contrarian had a better way of doing multiple IFs, but like you I'm self taught so I don't always use the most efficient way
|
|
By:
PS: Please get your interest rates spreadsheet more accurate at predicting changes :|
|
|
By:
hi
if I understand correct what you need place the following in q18 cell =IF(P18="QA";40;IF(P18="A";-20;"")) if the formula doesn't work at all replace ; with , |
|
By:
My two cents ~
=IF(P18="QA",40,IF(P18="SA",20,"")) |
|
By:
Typo should be
=IF(P18="QA",40,IF(P18="SA",-20,"")) |
|
By:
Actually it may have been you CM who had a good way of dealing with multiple IFs. I'm gonna have to dig it up
|
|
By:
Lori 06 Feb 07:57
PS: Please get your interest rates spreadsheet more accurate at predicting changes :| It got the top of the market dead right though, "Not Long Now" market to lose 1000pts this week. lol |
|
By:
typo from me also
=IF(P18="QA";40;IF(P18="SA";-20;"")) |
|
By:
oops, I did the same with the -20
|
|
By:
Thanks all, I will give it a wizz after brekkie
|
|
By:
IF
AL 40 QA 30 PR 20 HU -10 SA -20 any chance you can do all these in cell p18 and p19 please Pretty please |
|
By:
any chance you can do all these in cell p18 and q19
|
|
By:
=IF(P23="AL",40,IF(P23="QA",30,IF(P23="PR",20,IF(P23="HU",-10,IF(P23="SA",-20,"others")))))
|
|
By:
many thanks lori
that is a proper formula!! |
|
By:
=IF(P18="AL",40,IF(P18="QA",30,IF(P18="PR",20,IF(P18="HU",-10,IF(P18="SA",-20,"")))))
Enter into Q18 |
|
By:
Beat me to it lori
You've done that to me before Cheers |
|
By:
and thanks to you too compound.
I won´t live long enough to learn how to do these formulas!! |