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
Openoffice conditional formatting - Guide
Conditional formatting based on date ✓ - Excel Forum
Conditional Formating a word within a sentence - Resent - Excel Forum
Conditional formating is applied based on date in two cells ✓ - Excel Forum
Conditional hyperlink excel ✓ - 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

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Conditional Formatting: 3 range of numbers

Conditional formating - apply on more cells

Conditional formating of row based on other cells

Similar discussions

Subscribe To Our Newsletter!