Microsoft Office Standard for PC Logo

Related Topics:

Posted on Oct 12, 2007

How to write a Formula

Sir,

 Please help me to write a formula for the Below:

 

Basic Pay: 25000

Rent allowance: 30% of Basic Pay subject to Maximum of 5000

 

Now how to write a formula in a cell to find out Rent allowance

 

My Email ID: jayakumarbalaji@yahoo.co.in

 

Thanking You.

 

Yours faithfully,

 

Jayakumar, India

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

  • Contributor 5 Answers
  • Posted on Oct 12, 2007
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

Joined: Sep 03, 2007
Answers
5
Questions
2
Helped
1457
Points
2

Suppose your Basic Amount is in cell A5 then write a formula in B5 - If(A5*0.3>5000,5000,A5*.03) and copy this formula to all cells in coloumn B .

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

176 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3269 Answers

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3869 Answers

Brad Brown

Level 3 Expert

19190 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...