Help with Function

[Jane M]

I have a workbook that has all the days of the week as
well as a summary page. In cell e4 on the summary page I
want it took look at Mondays sheet in cell b18. If b18 is
No I want it to put the value of 80 in cell e4 on the
summary page. If the value is YES I want it to put 0 in
the cell.

I will be forever in your debt if you could help me out

 

[Bernard Liengme]

Hi Jane,
We need to know the name of Monday's sheet. I will assume it is Sheet1.
You reference a cell on another sheet, for example, =Sheet1!B18. Note the
exclamation mark. It is easy to make these references by typing or by
pointing. By pointing: type =; click on Sheet1 tab and the cell to be
referenced. If the sheet has a name with a space it in you get ='Two
Faced'!B18

Now for the IF formula: =IF(Sheet1!B18="No", 80, 0)
Excel is cased insensitive; this formula will work with NO, No, no in
Sheet1!B18.

But the formula assumes that if the cell does not contain No then it is to
be treated as if it contained Yes. Perhaps this is not what you want.
Try: =IF(Sheet1!B18="No", 80, IF(Sheet1!B18="Yes", 0, "Don't know"))

So am I in your debt? Have a glass of red wine to toast my health - the
antibiotic I'm on precludes alcohol!

 

[Frank Kabel]

Hi Jane
try the following in E4
=IF('Mondays'!B18="No",80,IF('Mondays'!B18="YES",0,"neither yes or
no"))

HTH
Frank

 

[Bob Phillips]

Hi Jane,

=IF(Monday!B18="No",80,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jane]

Thank you all for your help. Got it to work flawlessly!