Excel Tips

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 – 5cc $0.19 Slip Tip Syringes – 5cc… |
|
|
Excel 2003 Level 8 Tips & Tricks [VHS] $39.95 … |
|
|
EXCEL BURNISHER WITH 4 ASSORTED TIPS $5.95 EXCEL BURNISHER W/4 ASSORTED TIPS…. |
|
|
Microsoft Excel 2003 Tips, Tricks & Shortcuts presented by Dennis Taylor … |
|
|
Microsoft Excel 2007 $13.03 … |
|
|
Excel 2007 Training Videos – 10 Hours of Excel 2007 training by Microsoft Office Specialist Master Instructor: 2000, XP (2002), 2003, 2007 and Microsoft Certified Trainer (MCT), Kirt Kershaw $39.95 Are you looking for Affordable, in-depth, high quality, easy to follow Microsoft Office Excel 2007 training videos? Well, look no further because our training videos are developed & trained by a Microsoft Certified Applications Specialist & Microsoft Certified Trainer, Kirt Kershaw. With 118 training videos and over 10 hrs training offered in Flash & Windows Media Video formats you will have ever… |
|
|
Microsoft Excel 2007 Computer Based Training DVD Rom – Learn MS Excel with 6 Hours of Lessons on CD That Are Well Organized From Basic to Advanced Features. Over 225 Excel Features Explained By an Experienced MS Office Instructor: Brush up on Your Computer Software Skills with CBT Spreadsheet / Spread Sheet Training $39.95 With more than 6 hours of instruction, this comprehensive Microsoft Excel 2007 End-User Computer-Based Training Module features. Step-by-step video instruction led by an experienced Excel 2007 instructor The CBT includes instruction on the… |
|
|
Microsoft Office 2007 Complete Quick Start Card Bundle – Bundle of 14 Handy Software Reference Guides – 1 for each Office 2007 Program: Word, Excel, Outlook, Outlook WA (Web Access), PowerPoint, Publisher, Access, Project, InfoPath, OneNote, Visio, Groove, Internet Explorer 7 & Vista – Computer Shortcuts, Cheats, Tips & Tricks Guides. 6 Pages Ea, Tri-Fold. Stores Easy. $49.95 The Microsoft Office 2007 Complete Quick Start Card Bundle includes everything you’ll need to learn the basic features of all Microsoft Office 2007 Programs- Word, Excel, Outlook, Outlook WA (Web Access), PowerPoint, Publisher, Access, Project, InfoPath, OneNote, Groove, Internet Explorer 7, Vista & Visio. Includes 11 durable, 6 panel, tri-fold cards, one for each application…. |
Tagged with: excel • excel tips and techniques • excel tips and tricks • excel tips and tricks 2007 • excel tips and tricks pdf • excel tips vlookup • howto • microsoft • reference • tips
Filed under: Excel Tips
Like this post? Subscribe to my RSS feed and get loads more!

Leave a Reply