Help with Function

  • Thread starter Thread starter Jane M
  • Start date Start date
J

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
 
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!
 
Hi Jane
try the following in E4
=IF('Mondays'!B18="No",80,IF('Mondays'!B18="YES",0,"neither yes or
no"))

HTH
Frank
 
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)
 
Back
Top