# 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.

But

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

But

(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

( 4 reviews ) Sydney, Australia

Project ID: #27961104

## Awarded to:

MimiFL

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)
7.2

## 16 freelancers are bidding on average \$19 for this job

hdlan

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)
6.4
saif12me

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)
5.9
sevillajk01

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)
4.9
IgeS

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)
4.9
ShakeelASESE

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)
4.2
Akib2020

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)
4.4
rameshraja86

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)
3.9
jnpkfb

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)
2.6
Shodi39

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)
1.9
hamzakweyu

\$20 AUD in 1 day
(0 Reviews)
0.0
tripathivikas28

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)
0.0
laxmi127667

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)
0.0
aryan122003

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)
0.0
OMSW

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)
0.0
Indianexcelex

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)
0.0