Excel Tips
Monday, April 12th, 2010 at 4:37 pm
Leave your comment
Ms Excel Formula tips (Not VBA)?
how do i insert a value in a cell from another cell
cell A1=if(sum(A5:A12)>25,F12=”Good Result”, F12=”Bad”)
the calculation will be displayed in cell A1 and cell F12 the result. I dont want cell F12 to contain any formula but just the result of the calculation in A1. is it posible?
p/s: i dont want to use VBA though its easier.
Excel functions must be enterred before it is calculated
The only way to do it without VBA is may be using scinarios, did you tried it?
I am sure can help you
I am after all the VBAXLMan here
mail me to show you how, it can not be shown here
VBAXLMan
Microsoft Excel #05: Tips, Tricks, & Form Creation
|
|
Slip Tip Syringes – 10cc $0.18 Slip Tip Syringes – 10cc… |
|
|
Slip Tip Syringes – 30cc $0.72 Slip Tip Syringes – 30cc… |
|
|
Slip Tip Syringes – 50cc $0.90 Slip Tip Syringes – 50cc… |
|
|
Excel 2003 Level 8 Tips & Tricks [VHS] $39.95 … |
|
|
Microsoft Excel 2003 Tips, Tricks & Shortcuts presented by Dennis Taylor … |
|
|
Microsoft Excel 2007 $13.24 … |
|
|
EXCEL BURNISHER WITH 4 ASSORTED TIPS $5.95 EXCEL BURNISHER W/4 ASSORTED TIPS…. |
|
|
Microsoft Excel 2007 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts – Laminated Card) $3.60 Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2007. The following topics are covered: Creating Workbooks, Entering and Editing Data, Clearing Cells, Undo and Redo, Inserting and Deleting Rows Columns and Cells, Column Width and Row Height, Entering Dates, Entering Sequences, Entering Formulas & Functions, Using AutoSum, Absolu… |
|
|
Statistics for Management and Economics (with CD-ROM) $139.00 STATISTICS FOR MANAGEMENT AND ECONOMICS, 8e, emphasizes applications over calculation. It illustrates how vital statistical methods and tools are for today’s managers–and teaches you how to apply them to real business problems. Using a proven three-step “ICI” approach to problem solving, the text teaches you how to IDENTIFY the correct statistical technique by focusing on the problem objective an… |
|
|
Microsoft Office Excel 2007 $27.97 This Microsoft Office 2007 Illustrated Series book covers the essential information that you need to know about how to use Microsoft Excel 2007. Our signature two-page spread design has been updated and refreshed to take full advantage of the new features of the Office 2007 software. This practical, easy to navigate book provides you with the essential knowledge you need to succeed at both work an… |
