If formula

Dear Sirs …. Kindly need your help with below table to distinguish between + or - numbers in the result cell to take + value cell keep in mind the following If formula used in result cell ( if there...

microsoft 365

PeterBartholomew1

Jul 23, 2023

Alternative

= LET(
    s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))),
    VSTACK(s, SUM(s))
  )

Riny_van_Eekelen

Platinum Contributor

Jul 26, 2023

Yousef70 I don't see anything like "honored", "not honored" or "not due". I have no clue what you are talking about. Sorry.

Yousef70

Brass Contributor

Aug 04, 2023

Riny_van_Eekelen

Dear Riny...

Kindly , looking for your help in developing attached excel sheet further , I will elaborate on what is needed :-

First , I have started this sheet many years ago with two parts in it ( it is as a daily excel calendar ) :-

Upper part is for my business ( calculating break even point on profit margin provision )
Lower part is personal ( income distribution based on % of each expense to total expenses )

Second , profit margin provision is entered manually at day one of each month based on last month average

Third , weekends take half the daily cost ( sales are usually lower on weekends ) where weekdays take full cost + difference from weekends

Fourth , total sales needed to break even with cost is calculated based upon profit margin which is divided to weekdays and weekends accordingly

Fifth, I need to automate few things in this sheet :-

Need to have profit margin average automated on daily basses ( when data is entered ) . daily profit is at line 11 starts at cell T
Need to have all cells with profit margin update to daily average accordingly , for example cells C37 , J20 , K20 , etc.
Lost sales to break even point starts at line 12 cell T ( based on provision ) , need a formula at cell K20 to add lost sales daily after dividing it to remaining weekdays , same at cell P20 for weekends ( keeping in mind profit margin average ) , Also , if sales exceed the break even point , the formula will subtract from remaining weekdays for cell K20 and weekends for cell P20.

This it for know , we will fine tune accordingly

Thanks in advance

INCOM SHEET.xlsx3 MB

Yousef70
Brass Contributor
Aug 04, 2023
Dear Hans...

Noted
HansVogelaar
MVP
Aug 04, 2023
Yousef70

Forums such as this one, Microsoft Community and others are intended to help people on their way, not to create complete solutions for them.

If you make a start yourself and run into a specific problem, you are very welcome to post a question about it here. But if you want a complete solution, you should hire a professional developer.
Yousef70
Brass Contributor
Aug 04, 2023
Dear Riny

I understand , can you direct me where to go ?

Thanks
Riny_van_Eekelen
Platinum Contributor
Aug 04, 2023
Yousef70 Sorry, but that kind of work goes beyond the scope of my involvement in this forum

Forum Discussion

If formula

Resources