标题:Excel2007 “规划求解”
作者:jinwyp
时间:9/24 16:07
工资应该是多少？
在excel2007中，这是很简单的。表示如图1：
http://blog.officeba.com.cn/upload/200806070919531260.gif
图1
图1中只有B3:D4共6个单元格有数据，另外没有数据。其中只有D4单元格（黄色的那个单元格）有公式，在编辑栏可以看到这个公式。结果为3360元。
假设新工资要为3660元（即D4单元格为3360元），基础工资3000元不变，那么系数C4单元格为多少？
执行 数据---分析---规划求解，如图2：
http://blog.officeba.com.cn/upload/200806070919422677.gif
图2
可以看到，没有约束条件，单击“求解”即可以得出 ..
下页 上页
回复本帖|发新话题
回复列表 (4)
#1 [yanshen 9/24 16:55] 回复本帖
割腕者的天堂
===================
#2 [jinwyp 9/24 22:11] 回复本帖
ls什么意思
===================
#3 [yanshen 9/24 22:44] 回复本帖
下这个电影 记录一下
===================
#4 [yanshen 10/14 18:32] 回复本帖
ear Mr. Bentley ,
I am writing to express my strong interest in the position of Director of Human Resources at your company, as described in an advertisement on jobsearch.com. I am interested in your company, which has a reputation for company loyalty and the professional development of its staff. I believe that my background in personnel administration, my excellent communication skills, and my knowledge of your industry make me a strong candidate for the position.
As the assistant manager in the Human Resources department of my present company, I have had many responsibilities. I have researched legal matters, wrote reports for company policy, hired and trained new employees. Last year I organized an important project to analyze and make recommendations on the health care policy of our international employees. Since I have previously worked in both product development and sales and marketing. I have a wider range of experience than many others in my field. I believe that I apply this to my day-to-work in ways that make me a more effective leader of a diverse staff...
===================
<<下一主题
>>上一主题
返回板块