Quickie Excel help?

Django x2 · 27 Jan 2011 at 11:28

I have a column (D) of numbers. In column E, I would like a Y for Yes or N for No to appear in the number in column D is greater than or less than the number 5

So, if Cell D3 has a 3, Cell E3 shows a Y (less than 5)
If Cell D3 has a 8, Cell E3 shows a N (more then 5)

I'm sure it would be along the lines of:

IF(D3 > 5.....(something something)

Django x2 · 27 Jan 2011 at 11:32

If the number equals 5 it's a yes too

So what you've given me works fine, thanks

Django x2 · 31 Jan 2011 at 15:07

Ok, another quickie hopefully.

I have a cell which is NETWORKDAYS. It looks at the date in coloum b and c and works out the differences in days. However, if a weekend is within this period, I want NETWORKDAYS to subtract 2

So, I have a coloumn called Weekend which is a Y or N answer. I guess this is:

If cell =Y then -2

how do I formt that

Django x2 · 1 Feb 2011 at 10:41

Ok, thanks Morba, how do I add the if statement to the formula thats already in there?

At present, I'm trying:

=NETWORKDAYS(B7,C7), if(G7="Y",SUM(D7-2))

Where, B7 is start date, C7 is end date, D7 is the cell this is all going in and G7 is the Yes / No