Posted to microsoft.public.excel.programming

Mike H

external usenet poster

Posts: 11,501

Formula problems

It wasn't that difficult to track down!!

http://www.microsoft.com/office/comm...0-7454f7626c94

"sunnydazy" wrote:

Hello;
I sent in a question this morning but it seems to have disappeared. it is an
if and then situation. this was the first response, but it didn't work.

=IF(E1=1,J1+J5,IF(E1=2,J1+J6,""))

if cell E1=1 then add cell J1 to cell J5
if cell E1=2 then add cell J1 to cell J6

thank you for your help,

Sunnydazy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Problems	Ayo	Excel Discussion (Misc queries)	2	February 10th 10 01:24 AM
aauugghhh...#div/o problems & various average formula problems	acbel40	Excel Worksheet Functions	5	October 19th 09 05:00 PM
If formula problems	Canon	Excel Discussion (Misc queries)	4	May 6th 09 03:42 PM
Formula Problems	Mike	Excel Discussion (Misc queries)	3	September 14th 06 05:17 PM
Formula Problems	Ted	Excel Worksheet Functions	13	November 21st 05 08:14 PM

All times are GMT +1. The time now is 04:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us