Microsoft Office Forums


Reply
Thread Tools Display Modes

Excel question

 
 
Nocturnal
Guest
Posts: n/a

 
      07-03-2005, 12:58 AM
Ok now I have a cell where I want it to check another cell on the same
worksheet whether or not it says yes. If it says yes, then I want it to
perform a function on another cell on the same worksheet.



So say cell A1, A1 check cell B1 if it says yes. If cell B1 says yes then
in cell C1 perform a function such as (I want this to be on a different
worksheet) =sum(e17*d17). If not, then 0.



I put this in A1 =IF(B1="Yes",(PERFORM FUNCTION IN ANOTHER CELL ON ANOTHER
SHEET IN THE SAME WORKBOOK,0)



How do I link a =sum(e17*d17) from another sheet?




 
Reply With Quote
 
 
 
 
Ron Coderre
Guest
Posts: n/a

 
      07-03-2005, 01:07 AM
On Sheet2, C1: =IF(Sheet1!B1="Yes",SUM(E1717),0)

That is assuming you meant to add E17 and D17 on Sheet2. Your post is a
little ambiguous "=sum(e17*d17)".
If you want to add E17 and D17 on Sheet1 (not Sheet2), then:
On Sheet2, C1: =IF(Sheet1!B1="Yes",SUM(Sheet1!E1717),0)

Does that help?

Regards,
Ron


 
Reply With Quote
 
nika
Guest
Posts: n/a

 
      07-03-2005, 01:25 AM

Put in cell C1 =IF(B1="yes",D17*E17,0)


to link this to another worksheet simply select your preferred cell
type = then go to the worksheet with the formula in activate cell then
press enter

eg: =Sheet1!C1

hope this helps


--
nika
------------------------------------------------------------------------
nika's Profile: http://www.excelforum.com/member.php...o&userid=15360
View this thread: http://www.excelforum.com/showthread...hreadid=384131

 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
excel vba question levy.pate@baesystems.com Access Newsgroup 1 12-01-2005 04:33 PM
question on excel GC Access Newsgroup 1 10-26-2004 06:07 PM
Excel question... Mike Excel Newsgroup 2 04-12-2004 08:28 AM
Re: Please help with Excel VB question Scott Simpson Excel Newsgroup 0 01-14-2004 08:16 PM
Re: Excel Replacement Question J.E. McGimpsey Excel Newsgroup 0 09-19-2003 10:52 PM



All times are GMT. The time now is 02:23 PM.