if true, if not nested if funcion Having some trouble figuring out a formula. Hope someone can help! This is going to go into Cell B10. If cell b7 is =equal or greater> than the value in B12 only sum B6+B8+B9; however, is cell b7 is less than the value in B12 sum b6+B7+B8+B9. How would i write this as a formula for I am doing something wrong. ... 24 May 2010 14:36 What if scenarios using multiple worksheets Dear Friends Is it possible to have scenarios in XL 2003 across 2 or more worksheets? Which means, for example, I had some chaging cells in one sheet other cells in another worksheet and the result in the first one. I have tried lately but I got an error message. The same problem I have encountered with the... 24 May 2010 13:29 Yes - No Fill-ins & More Working in Excel, I am looking for help using fill-in boxes. I am creating a form. Setting up a cell or a bunch of cells merged where you can enter a question. Then that question can be answered with a filled-in by clicking in a "Yes", or "No" box. Then a "check mark" appears if their is not one, or, disap... 24 May 2010 12:21 120= rupees one hundred twenty only i just want to know the formula which translate digit to text for example if 120 written in any cell and other cell we want result "rupees one hundred twenty only" ... 24 May 2010 21:17 from the text 4 pcs., how to remove only characters/text Pls help me in the above subject i.e. from the cell contents in excel as "4 Pcs.", what is the formula to be used to remove only number and mention in a separate cell. i.e. cell should contain only numeric value, not the text. ... 24 May 2010 12:21 Calculate difference between current date & prior I am looking for a formula that would calculate the difference in dates but display in weeks-can this even be done? Col A Date Received 4/15/2010 Col B Approx Age in Weeks 2 I am trying to calculate the current age in weeks but cannot come up with the right formula. The closest I could get was us... 25 May 2010 10:13 How do I export a Pivot Table in Excel into Word? Please tell me how to do this. ... 24 May 2010 10:08 drop down list hi all, i am currently trying to create a worksheet which would have a drop down list containing descriptions from the description column (i.e. 1,2,3,4...10). description C2 C3 C4 1 a b c 2 d e f 3 g h i 4 j k l 5 m n o 6 p q r 7 s t u 9 v w x 10 y z 0 when i used validation for this ex... 24 May 2010 09:02 in MS EXCLE how we can protect only one cell? plz do repl me soon ... 24 May 2010 07:58 change color font after updated hi all, i work with excel everyday, sometimes i forget which one i already changed in that sheet. i.e in column D, i have a values. now every time i changes or update that column, the color of font will change automatically maybe red, yellow or anything. at least i can know the changed. many thanks for ur... 25 May 2010 03:44