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.

Taidot: Excel, Matematiikka

Näytä lisää: 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

Tietoa työnantajasta:
( 4 arvostelua ) Sydney, Australia

Projektin tunnus: #27961104

Myönnetty käyttäjälle:


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 Lisää

$15 AUD 1 päivässä
(564 Arvostelua)

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 1 päivässä
(46 arvostelua)

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 Lisää

$15 AUD 1 päivässä
(23 arvostelua)

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 1 päivässä
(38 arvostelua)

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 Lisää

$15 AUD 1 päivässä
(25 arvostelua)

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 1 päivässä
(8 arvostelua)

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 Lisää

$20 AUD 1 päivässä
(29 arvostelua)

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 Lisää

$20 AUD 1 päivässä
(14 arvostelua)

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 Lisää

$15 AUD 1 päivässä
(11 arvostelua)

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 1 päivässä
(1 arvostelu)

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

$20 AUD 1 päivässä
(0 arvostelua)

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 Lisää

$30 AUD 1 päivässä
(0 arvostelua)

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

$18 AUD 7 päivässä
(0 arvostelua)

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 Lisää

$15 AUD 1 päivässä
(0 arvostelua)

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, Lisää

$30 AUD 7 päivässä
(0 arvostelua)

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 1 päivässä
(0 arvostelua)