Excel help please

=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)

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

PS: Please get your interest rates spreadsheet more accurate at predicting changes :|

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 ,

My two cents ~
=IF(P18="QA",40,IF(P18="SA",20,""))

Typo should be
=IF(P18="QA",40,IF(P18="SA",-20,""))

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

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

typo from me also
=IF(P18="QA";40;IF(P18="SA";-20;""))

oops, I did the same with the -20

Thanks all, I will give it a wizz after brekkie

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

any chance you can do all these in cell p18 and q19

=IF(P23="AL",40,IF(P23="QA",30,IF(P23="PR",20,IF(P23="HU",-10,IF(P23="SA",-2...

many thanks lori

that is a proper formula!!

=IF(P18="AL",40,IF(P18="QA",30,IF(P18="PR",20,IF(P18="HU",-10,IF(P18="SA",-20,"")))))

Enter into Q18

Beat me to it lori
You've done that to me before
Cheers

and thanks to you too compound.

I won´t live long enough to learn how to do these formulas!!