Excel question

  • Thread starter Thread starter Nocturnal
  • Start date Start date
N

Nocturnal

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?
 
On Sheet2, C1: =IF(Sheet1!B1="Yes",SUM(E17:D17),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!E17:D17),0)

Does that help?

Regards,
Ron
 
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
 
Back
Top