Previous Topic Next Topic

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

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?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response
Applying conditional formatting rule to other rows
FrejaOlsen -
TrowaD -

1 response
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses