RE: Formula help

[Bazola]

RE: Formula help

Hi All

I am after some help if you dont mind..

I basically have a sheet called "Survey's & Checklists" and within that I have a Cell E3 (PS Survey Completed) for which I would enter "Yes". I also have another cell in that sheet (PS Survey Completed Date) G3. I also contains a "Site Go live Cell" C3, and a "PS Survey - 10 weeks Prior to the Site Go Live" D3 - this basically works takes off 70 days off the Proposed go live date and gives us a date. The other cell is called "PS Survey Days Remaining" F3

I then have another sheet called OTR Status Dashboard, with a Cell Called "PS Survey Completed in Timeframes?" E3, Basically I want this cell to remain blank until both E3 and G3 are filled in on the other sheet.

So far, I have done this on the OTR Dashboard Cell E3

=IF('Survey''s & Checklists'!F3<=0,"No,not completed in time", "Yes, Everything is fine")

Can you advise how I can get it only to fill in the cell E3 on the OTR Status Dashboard once "PS Survey Completed" E3 & "PS Survey Completed Date" G3 have been populated?

Many thanks
Bazola

 

[oldbrewer]

Re: Formula help

=if(and(E3<>"",G3<>""),......

E3 and G3 will of course have the sheet ref in front of them

 

[louisH]

Re: Formula help

Hi,

Not sure i got it but here's the following :

=IF(AND('Survey's & Cheklists'!E3 <> "", 'Survey's & Chelists'!G3 <> ""),IF('Survey's & Checklists'!F3<=0,"No,not completed in time", "Yes, Everything is fine"),"")

Hope it helps

 

[Bazola]

Re: Formula help

Brilliant, thanks so much for your help both