yes no calculation (More info)????

[Chris Watson]

Is it possible to put a Y, yes N, no formula into excel.
I am putting together a daily time sheet for an HGV driver (Myself)
and have most of it completed thanks to the tips from this forum.
There are 8 sheets named Mon, Tue, etc with a summary sheet as No 8,
the Y, N formula i need is whether or not the driver did a night out or
not and calculate on the 8th sheet how many nights out was done that
week.

Chris

 

[Norman Harker]

Hi Chris!

If your Y / N is user input:

=IF(A1="Y",Calculation,"")

Alternatively, you may have information that defines whether the
driver did a night out. So you might have:

A1:
=IF(DefinitionOfNightOut,"Y","N")
A2:
=IF(A1="Y",Calculation,"")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.