Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

If or problem

Comment:

Hello. I have a complicated formula problem. I have a summary list of values per month from Jan to Dec. If I enter a month in my report, say January, how can I get Excel to pick the correct months value and report on it, regardless of which month it is. eg Month..Value Jan..49 Feb..20 Mar..5 Report to show Month 49 (because the month I have already selected is January). Thank you,

lotus notes error

no date showing in outloo...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Could be a virus or some malware - running in safe mode means that the malware won't run. Use spybot search and destroy as well as antivirus software. Reinstall office if the problem persists then it ...

Summary: Mirtha If your data is in columns A:E, in column F add a formula to produce a proj of 001/002 if the proj is 001 or 002 otherwise producing the normal proj: =IF(OR(B2="001",B2="002"),"001/002",B2) In ...

Summary: You don't need a nested If statement, there is a operator for the OR operand. =IF(OR(B2=1,B2=2,B2=3,B2=4),"true","false") Michael J...