Multiple IF statements

[LISA H]

I have a workbook that has several sheets. 40 of the sheets are combined into a summary sheet. I need help with a formula.

Here is what I need it to do:
On Sheet "1" if load date=6, then show B47
On Sheet "1" if return date =6, then show B47
On Sheet "1" if 6 is between load date and return date, then show B47.

Any suggestions?

 

[PA HS Teacher]

Lisa,
Instead of hitting copy to clipboard, hit the view source button right next to the copy to clip board button. Edit copy all, and paste that instead. That way you want get all of the nsps... in there.

 

[Von Pookie]

Lisa,

I had to remove your previous examples as they were affecting the way the page was displayed. Please make sure you copy and paste the entire code when using an HTML Maker example.

 

[LISA H]

multiple if statements

Erik,

Thank you so very much for your suggestions.

Somewhere in the middle of the night - I realized I was making this harder than I needed to. I came up with a simple IF And formula, and it works!

Again - thank you for your patience and guidence.

Lisa

 

[erik.van.geit]

Lisa,

Yes, even when we help not really to get the solution iself, it's often just the fact we know we're not alone with the problem that helps.

But since I've spent about half an hour trying to figure out what you meant ... could you post what your solution was ? Finally we could grasp

kind regards,
Eirk