I'm using Excel 2010 and saving my worksheet in Workbook Excel-Macro Enabled Workbook or Excel Workbook. Numbers with decimals will add/subtract,multiply and divide. However, formulas using Min/Max, IF, And, Median etc; do not return correct results, in this case "Y","N". Numbers with decimals default to "N". All cells are formatted as numbers with 3 decimal places left of the whole number. Auto Calculate is on. .
I hope this example will help. Range: 143.264 - 145.689 Formula: =IF(H12=MEDIAN(K5:O5),"Y","N") where H12 (144.395) K5 (143.264) and O5 (145.689) are the cell values. The formula returns the correct result "Y" if the cell values are whole numbers and "N" for numbers with any decimals.
Hi,
I am an excel VBA expert and would like to go through the excel file. Please go through my profile and reviews so that you can be confident about me.
Hope to chat with you soon
Thanks
sajid
'Hi there'
I have read your project description and i got you Need An Excel Expert. I am professional data entry operator and I have lot of experience on ms office and other database software’s . I can give you professional looking designs on low cost in minimum time period. You can decide about my payment after watching my work and proficiency. i am always on time and my employers are always happy with me.
Regards
Malik Adnan
Dear client
I have been working on Excel, word, PowerPoint since last five years. If you are looking for data entry, excel, word, PowerPoint then I am a right person for you.
I am sure you will find our data Entry a hot shot & our each work of Microsoft phenomenal.
We have a good Experience & will leave no stone unturned to prove our worth.