I Need An Excel Expert

$10-30 USD

Completed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

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.

Project ID: 18242527

About the project

8 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@sevillajk01

hello! let me help you with your project. Just award the project to me, share with me additional details and I will take care of the rest. thanks

$20 USD in 1 day

5.0

(30 reviews)

4.6

8 freelancers are bidding on average $23 USD for this job

@sajidkhan45

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

$25 USD in 1 day

4.2

(69 reviews)

5.8

@DesignEnlight

HI, I am an expert in EXCEL . I have read the problem. I can solve your problem. Ping me for more discussion. I have 9+ years of experience. thanks

$25 USD in 0 day

5.0

(1 review)

0.1

@MalikAdnan593

'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

$10 USD in 1 day

5.0

(1 review)

0.0

@vandykagwe

very good at this.. best work and smart Relevant Skills and Experience i have computer knowledge, and it related devices

$25 USD in 1 day

0.0

(0 reviews)

0.0

@usmanmaan1994

Dear Sir i am excel expert and know about all excel commands like vlookup h lookup if then analysis ..give me a chance and feel free to contact thanks

$30 USD in 1 day

0.0

(0 reviews)

0.0

@wwwashishgoyal

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.

$17 USD in 1 day