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.
16 freelancers are bidding on average $19 for this job
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.