IF help

[andrewb90]

Hello,

I have been trying to do an IF formaula, and can't quite seem to get it right. It is a nested IF so here is the first part:

=IF(H35=0,"-",

My value if false need to be an IF statement that takes M23,M26,M29,M32 and if any of those values (Which is time only) is greater than M20 then a positive value will be "Yes" and Negative will be "No"


Thanks

Andrew

 

[Snakehips]

You are welcome.
Now get on with your cooking!!

 

[rmwindham]

Question about a nested IF, I am having a problem getting my formula correct, so I am hoping for some help. I have a column A1 (Opening Date), that will have a date entered, B1 (Days since open) the formula will add the days since A1 and give a number, (That part I got; Today()-A1) but if C1(Ending Date) has a date entered then B1 will be blank. Any Help will be appreciated.
A 2nd question will be; if B1 is greater than 90, I need that row of info to be extracted to another tab?
Thanks

 

[Snakehips]

rmwindham,

Below should answer your first question but not the second re extraction.

I would suggest that you start a new thread with a clear explanation f what you have and what you are looking to achieve.

Excel Workbook
	A	B	C	D
1	02/08/2014	23
2	26/05/2014	91		Needs Moving
3	04/08/2014		17/08/2014
Sheet3

Hope that helps.