Conditional formating

Closed

sunayana - May 13, 2010 at 12:51 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 13, 2010 at 09:03 AM

i want formula for hoe to calculate p.t in excel if any persons salary is more than 5000 the it's 175/- and for monr than 10000 then its 200 so how to calculate by putting only one formula

Conditional formating
Excel conditional formatting if another cell contains specific text - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Excel formula to change cell color without conditional formatting - Excel Forum
Conditional formatting 3 color scale percentages ✓ - Excel Forum
Copy conditional formatting but change reference cell ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 13, 2010 at 09:03 AM

=IF(a1>= 10000, 200, IF(A1>=5000, 175, 0))

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

one cell will turn green when the two other cells match

Conditional formating - apply on more cells

Similar discussions

Subscribe To Our Newsletter!