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)

Malakite · 27 Jan 2011 at 11:31

What is the number equals 5?

so =if(d3>=5,"N","Y")

This is if everything greater than or equal to 5.

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

Malakite · 27 Jan 2011 at 11:33

cool, then it is just

=if(d3>5,"N","Y")

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

Morba · 31 Jan 2011 at 16:06

=IF(E3="Y",SUM(D3-2),D3)

replace E3 with the cell for the weekend cell.

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

cotton31 · 1 Feb 2011 at 14:01

You'll want:

=IF(G7="Y",NETWORKDAYS(B7,C7)-2,NETWORKDAYS(B7,C7))