Fix my excel formula

Please fix the formula in my excel sheet attached.

Refer to attached PDF and work on attached excel sheet.

Details of how I want the formula to work:

(1) If 7B = >0 then 30F = 0.


(2) If 7B = 0 then cell 30F = average $/sqm (column R) of "s" (column P) (level 2)


(3) If there is no "s" in column P I want cell 30F to be "-"

I have the formula working for points 1 and 2 however not 3. If you can incorporate point 3 that'd be great.

Skills: Excel, Mathematics

See more: excel formulas, excel formula parser, check formula in excel shortcut, online excel formula checker, excel formula debugger online, online excel formula generator, excel formula breakdown tool, error in formula in excel, please fix myspace, register_globals disabled phpini please fix, can please fix website, please fix photoshop picture, please fix pic, macro fix excel 2007, virus please fix, please fix photo, excel web query fix data position, please fix spelling italian, mysql fix excel, fix excel macro error

About the Employer:
( 4 reviews ) Sydney, Australia

Project ID: #27961104

Awarded to:


Hi, yes this is possible. I would like to clarify few things about the formulas. I believe i can help you with this in matter of minutes. I've completed hundreds of excel projects without a single problem. Thanks, Mil More

$15 AUD in 1 day
(564 Reviews)

16 freelancers are bidding on average $19 for this job


Hi, I have updated formula in a cell F30 already. I will send an updated file immediately. Would be great to hear from you, Duong

$10 AUD in 1 day
(46 Reviews)

Hi there I would love to help you with the correction of excel formulas. I'm well versed with Excel VBA/Macro, complex formulas, pivot tables, etc. Quality and work accuracy is my first priority. Hope to hear from you More

$15 AUD in 1 day
(23 Reviews)

hi, I have checked you spreadsheet and I can help you with the formula. Just message me and will share it with you. Thanks!

$15 AUD in 1 day
(38 Reviews)

Hi there, Want you need is a formula that will check if there is "s" in Colum to return "-" in F30 otherwise return the result from the 1st two formulas? Please message me if this is any of what you need. I'll be st More

$15 AUD in 1 day
(25 Reviews)

Hy I am an excel Expert and I can do this perfectly. I can do accordingly. let have a chat for more discussion. thanks

$35 AUD in 1 day
(8 Reviews)

Hi there! Checked: Free lancer task [login to view URL] I’m expert on Advanced Excel, VBA, Macro, Nested IF, Sumifs, Countifs, Averageifs, vlookup, hlookup, array etc Complex Formula & Function and Microsoft Excel related various a More

$20 AUD in 1 day
(29 Reviews)

Hi I can develop any complex formula in Excel and Excel VBA I understood your logic requirement with IF statement It can be done in few minutes Pls contact me to start the work and complete in few minutes Waiting f More

$20 AUD in 1 day
(14 Reviews)

Hi there, I can do your project with 100% accuracy. I have reviewed your "Fix my excel formula" project brief carefully and would like to assist you with the task. Please check via this link what are the my clients More

$15 AUD in 1 day
(11 Reviews)

Hi, I have fixed the formula. Can share proof with you on chat. Now if there is no 'S' in Column P then cell F30 will show '-'. Looking forward to working with you.

$20 AUD in 1 day
(1 Review)

Let me be the one to help you with your Excel tasks. Quality and professional work [login to view URL] you!

$20 AUD in 1 day
(0 Reviews)

6 years exp of IT & Credit Card portfolio Business/Data Analysis. Tool: Advance MS Excel, MySQL,Tableau, Google Data Studio, Google sheet, logo designing, banner, poster designing. I can do the Business and data analys More

$30 AUD in 1 day
(0 Reviews)

I am a professional in Excel formulae and had worked extensively on excel sheets for various institutions in India.

$18 AUD in 7 days
(0 Reviews)

Hlo sir. my name is ARYAN I can provide you better support on social media because I have experience of doing social media marketing and I can serve you better. See I know sir I am new in freelancing site but work wi More

$15 AUD in 1 day
(0 Reviews)

Hello, I am mathematician and have a good statistical finiancial skills on excel. Now i work in a bank as market risk manager, lets see your task and send me your task description. =IF(B7>0,0,IF(B7=0,AVERAGEIFS(R8:R17, More

$30 AUD in 7 days
(0 Reviews)

Hello. The fix is quick it will not take more than 1 hour. let me know if you wish to connect for the same. Hope to give you quick solution.

$15 AUD in 1 day
(0 Reviews)