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 based on date - Guide
Conditional formatting if cell contains text - Excel Forum
Conditional formatting between two values ✓ - Excel Forum
Highlight cell if another cell contains any text ✓ - Excel Forum
Excel conditional formatting based on another 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

Highlight cell if another cell contains specific text

Conditional Format Cells Based on Another Cell and Own Cell

How to use conditional format based on text?

Conditional formatting based text in another cell

Conditional Formatting - highlight overdue dates

Similar discussions

Subscribe To Our Newsletter!