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

Taidot: Excel, Matematiikka

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

Projektin tunnus: #27961104

## Myönnetty käyttäjälle:

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

\$15 AUD 1 päivässä
(564 Arvostelua)
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 1 päivässä
(46 arvostelua)
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 Lisää

\$15 AUD 1 päivässä
(23 arvostelua)
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 1 päivässä
(38 arvostelua)
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 Lisää

\$15 AUD 1 päivässä
(25 arvostelua)
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 1 päivässä
(8 arvostelua)
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 Lisää

\$20 AUD 1 päivässä
(29 arvostelua)
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 Lisää

\$20 AUD 1 päivässä
(14 arvostelua)
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 Lisää

\$15 AUD 1 päivässä
(11 arvostelua)
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 1 päivässä
(1 arvostelu)
1.9
hamzakweyu

\$20 AUD 1 päivässä
(0 arvostelua)
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 Lisää

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

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

\$15 AUD 1 päivässä
(0 arvostelua)
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, Lisää

\$30 AUD 7 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0