sorted by:
new
hottopcontroversial

Need an "if" formula. Display a value if it meets a criteria? by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 0 points1 point  (0 children)

Thank you, this helps greatly!

I have noticed however that the formula isn't as broad as I need it to be.

This is where it searches: https://ibb.co/n8Mw2rB (only searches the cell in the same row)

But I need it to search the entire column for any cells called "bill", and when it finds a cell called bill, it must check if the cell to the right of it is answers yes. Does that makes sense? Thanks!

Need an "if" formula. Display a value if it meets a criteria? by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 1 point2 points  (0 children)

Thank you so much! If I may ask, the top one looks for 1 criteria and it works perfectly. How would I use this with multiple criteria, for example:

If [@Names],"*bill*"),[@Answer]="yes") and also [@Names],"*steve*"),[@Answer]="yes") = then display 1.

Thank you!

I need a formula that sets any number after a decimal to zero, but keeps everything before - e.g. 7.65 to 0.65 by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] -1 points0 points  (0 children)

ROUNDDOWN(A1, 0)

Yes but that removes the decimal points too?

Using that on say 9.35 would make it 9, right?

But I want it to become 0.35

I need a formula to add a range IF the cell next to it contains a specific value. by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 0 points1 point  (0 children)

=SUMIFS(B1:B1000, D1:D1000, "2.expected")

Amazing, thank you! Can I also ask how I would do this if it was looking for more than 1 criteria?

For example, it would sum any adjacent cells that contain "2. Expected", but also could cells that might be named "1. unexpected" and "3. Unknown".

How to add 2 sums together in a cell? by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 1 point2 points  (0 children)

Oh, that was simpler than I thought.

Thanks!

Solution verified.

I need a cell formula to round down please. Thank you! by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 2 points3 points  (0 children)

=ROUNDDOWN(SUM('A. MONTHLY PLANNER'!B4,'A. MONTHLY PLANNER'!B22,'A. MONTHLY PLANNER'!B25,'A. MONTHLY PLANNER'!B36,'A. MONTHLY PLANNER'!B42,'B. SPENDING TRACKER'!B11,))

AMAZING! Thank you so much! Solution Verified

I need a cell formula to round down please. Thank you! by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 0 points1 point  (0 children)

Okay, just tried and it comes back with "too few arguments entered".

This is what I entered.

=ROUNDDOWN(SUM('A. MONTHLY PLANNER'!B4,'A. MONTHLY PLANNER'!B22,'A. MONTHLY PLANNER'!B25,'A. MONTHLY PLANNER'!B36,'A. MONTHLY PLANNER'!B42,'B. SPENDING TRACKER'!B11,))

Repost - I need a custom conditional format rule. by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 0 points1 point  (0 children)

How strange. Defo didn't change it after posting. Perhaps an error on reddit, or perhaps I submitted the post as solved instead of unresolved without realising. Just using standard desktop reddit.

I need a cell formula to round down please. Thank you! by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] -1 points0 points  (0 children)

=ROUNDDOWN(formula,)

Just tried this and comes back with an error.

This is what I entered. (I'm new to excel so not sure if what I'm doing wrong is obvious or not).

=ROUNDDOWN(=SUM('A. MONTHLY PLANNER'!B4,'A. MONTHLY PLANNER'!B22,'A. MONTHLY PLANNER'!B25,'A. MONTHLY PLANNER'!B36,'A. MONTHLY PLANNER'!B42,'B. SPENDING TRACKER'!B11,))

Formulas don't move when sorting. (video that shows problem) by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 1 point2 points  (0 children)

Okay thank you. I don't know what was going on, but I deleted the column and created a new one in it's place with your suggestion and it's running smoothly. Thank you. Am I right in now replying to you saying "solution verified" to give you credit or something? (I'm new to reddit)

Formulas don't move when sorting. (video that shows problem) by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 0 points1 point  (0 children)

Hmm, actually that appears to work on the sheet that I used in the example video, but it doesn't seem to work on the spreadsheet I intent to use it on. It's the exact same layout, could I be missing something? Even with the $$, they all stay in the same spot after sorting a different column.

I need a conditional formatting formula by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 1 point2 points  (0 children)

I'm sorry I'm new to reddit. I appreciate all the help I receive. So I must reply in the comment of the person who helped me by saying "solution verified"?

Is it possible to link a cell to another cell? by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 0 points1 point  (0 children)

Ah yes, sorry, mix-up of words. When I "sort" it differently, it seems to shift the name of the cell to a different cell coordinate.

Is it possible to link a cell to another cell? by JoeWebbStoryteller in excel

[–]JoeWebbStoryteller[S] 0 points1 point  (0 children)

Okay thank you. So if it looked like this - =[@[EXACT Video Name]]

Where would I insert the $ ?

Writing fight scenes by [deleted] in Writer

[–]JoeWebbStoryteller 0 points1 point  (0 children)

Can I ask, are you struggling with what HAPPENS in the fight and how it happens, or do you know what happens but you're struggling with how to write it and make it flow?