Previous Topic Next Topic

Conditional formating

Closed
sunayana - 13 May 2010 à 00:51
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 13 May 2010 à 09:03
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 May 2010 à 09:03
=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