{"boardId":"excelgeneral","messageSubject":"please-help-me-with-an-excel-formula","messageId":"774140","replyId":"774384"},"buildId":"E37e9rqmzENIUrF3G1YvE","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled"...
I will need to do this calculation on a monthly basis for each Sunday School class. File A is created using a child’s attendance record for the last 6 weeks and thus will be different every month. Can you help me write a formula to search for each needed Family ID listed File A, a...
Excel formula help Screenshot 2024-04-27 123630.jpg Hi, I am trying to re-write a formula for K7. The formula in K7 works fine as long as I have data in F7 and J7 =SUM(F7*0.6 + J7*0.4). Where I am having problems is if F7 or J7 = 0. If either cell F7 or J7 equals...
Need help on writing this formula from Excel on a pdf form Olive34912443hduh New Here , Mar 14, 2024 Copy link to clipboard =IF(AND(cell a>=0.01,$call a<=0.3724),"X","")appreaciated for the help in advance. TOPICS JavaScript , PDF forms Views...
Excel Formula: =WORKDAY.INTL(C1+1,-1,"0111111") Upvote 0 Solution K keef2 Board Regular Joined Jun 30, 2022 Messages 185 Office Version 365 Platform Windows Oct 14, 2022 #5 Fluff said: What exactly do you mean by "closest Monday"? Think I got it? =IF(WEEKDAY(C1,2...
I want to add a formula that will add only the hours that fall between 1500 and 0700. Any help would be very much appreciated. Thank you. Excel Facts VLOOKUP to Left? Click here to reveal answer 1 2 Next Sort by date Sort by votes D Dave Patton Well-known Member Joined...
Can help me to re-build excel formula? Archived Forums 161-180 > Excel for Developers 問題 Hello, I need to help rebuild array formula for datasets. I has an example of array formula, please see below I shared a cut of formula, but it needs to be changed based on request: ...
I am trying to figure out how to create a formula that will give me the difference between the Awarded Green Sheet number and the Not Awarded Green Sheet Number for the subcontractors with the same trade and same project. Attached is an image of what I am looking for. ...
Writesonic (Independent Publisher) wttr.in (Independent Publisher) X X12 Xbridger Document Manager XC-Gate xkcd (Independent Publisher) Xooa Blockchain Database Xooa Blockchain Smart Contract Xpertdoc (Veraltet) [VERALTET] XSOAR (Independent Publisher) YakChat Yarado Yeeflow Yeelight Yelp (Independe...
Without that it sends me to the login page. I see that I go to the site, allow two scripts; it reloads; then I have to go back and allow a third one. Sigh. (The script apparently saves a cookie.) Anyway, now downloaded through the phalanx of scripts, looking at the formula - ...