Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Help with formula

by Jimrin1967 Feb 26, 2007 7:07AM PST

I am trying to figure out how to format an IF equation for the following:

I want column Q (Average) to be the average of column O (Eta MOS), Column P (GFS MOS)and then either column L (850 tmp high) or column N (with clouds. What I want to do is have the program look at column K (sky cover) and from that, determine whether to average in column L or column N.

In other words, I want it to say IF(column K is C, MC, R, S, TSTM) then use column N, else use column L.

Can this be done in excel? If so, can anyone help with how?

Thank you.

http://i57.photobucket.com/albums/g219/Jimrin1967/FCSTSHT.jpg

Discussion is locked

4 Posts
- Collapse + Expand Details
- Collapse -
Re: formule
by Kees Bakker Feb 26, 2007 3:59PM PST

I didn't have a look at your exact formula, so I'll give a somewhat abstract form
=IF(Kx="C",formula(Nx);formula(Lx))

With formula(Y) being a formula or a function using cell Y.

Hope this helps


Kees

- Collapse -
Thank you
by Jimrin1967 Feb 27, 2007 12:31AM PST

Thank you, Kees. The problem I have, though, is I want Kx to be multiple variables. In other words, IF(Kx="C,D, or E",formula(Nx);formula(Lx)

- Collapse -
Nevermind...I got it!!
by Jimrin1967 Feb 27, 2007 1:39AM PST

Thank you again for your input. It was a tremendous help!!

Jim

- Collapse -
Glad I could help.
by Kees Bakker Feb 27, 2007 4:39AM PST

So you found the OR-function yourself? That's OR(cond1,cond2,cond3), not cond1 OR cond2 OR cond3.
Good job.

Kees

Back to Office & Productivity Software forum

CNET Forums

Operating Systems
Software
Electronics & Gadgets
Hardware
Tablets & Mobile Devices
General Help
Brand Forums
Roadshow Autos
Off Topic

Other Forums

Forum Info