Conditional formating

Closed
sunayana - May 13, 2010 at 12:51 AM
rizvisa1 Posts 4479 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 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 13, 2010 at 09:03 AM
=IF(a1>= 10000, 200, IF(A1>=5000, 175, 0))
0