Microsoft Excel formulae....... How to do this?
|
|
 May 1 2008, 11:20 PM, updated 18y ago
Return to original view | Post
#1
|
 
Senior Member
684 posts Joined: Dec 2007  
|
well i wanted to google but i cant think of the key words so...
 i want a formula to count Months from one point to ANOTHER point and NOT a formula to count Months from one point to CURRENT point/time does anyone know how to do this?? i want to do something like "If point A to B is 10 months, do action A" and "If point A to B is 20months, do action B" help pls |
|
|
May 2 2008, 10:18 PM
Return to original view | Post
#2
|
|
Senior Member
684 posts Joined: Dec 2007
|
QUOTE(firedauz @ May 2 2008, 01:22 AM) Its best if you ask this specific question from Software or Codemaster section. ah yah but would that be double posting?(Q&A is like for general questions) You'll have much better chances in those 2 sections, gudluck   QUOTE(PSY84 @ May 2 2008, 10:13 PM) use the IF() function, if(logic, true, false) eg =if(C1=10, B2+C2, B3+C3) yeah i know that IF function and logical test ETC but i wanna know how to set one logical test to calculate months???it's like if c1=10, then B2+C2, else B3+C3 or you can do multiple loop/condition inside eg =if(if(if(......) ) ) |
| Change to: |  0.0139sec
 0.23
 6 queries
 GZIP Disabled
Time is now: 12th December 2025 - 05:44 AM |
Quote