Excel

This query is : Resolved

pankaj tiwari (Querist)
Follow

24 June 2013 how to use if function in excel for following
basic pay is rs1000
so
EA@10%of basic salary for officer drwaing a basic pay of rs 4500 ad abovee, subjected to maximum of rs 600pm.
plaese rply ASAP

CA Kapil Verma

CA Kapil Verma (Expert)
Follow

24 June 2013 you can use IF function.

pankaj tiwari

pankaj tiwari (Querist)
Follow

24 June 2013 sir that s what i knw i need to use if function but indeed how to do tat if u can tell den i ll b higly obilige..

Upgrade to CAclubindia Pro. Subscribe Now!

CA Kapil Verma

CA Kapil Verma (Expert)
Follow

24 June 2013 let suppose

Cell A1 = basic pay

Cell A2 = if(a1>6000,600,a1*10%)

this is result 10% of basic pay but total amount will not exceed 600.

if still have query please feel free to call 0120-4560193

pankaj tiwari

pankaj tiwari (Querist)
Follow

24 June 2013 thanking thanking a lot more thanking to u finaly i bcm succeeded to wch i want to all bcs f u (y) nd yeah l8r on whn i rqr i ll make call may I?

CA Kapil Verma

CA Kapil Verma (Expert)
Follow

24 June 2013 you are welcome.

pankaj tiwari

pankaj tiwari (Querist)
Follow

18 August 2013 hello will you please resolve my one more query ??
how to create purchase order for services(without item) in tally9