IFs formula for google sheet

[maniacs205]

Hi,

I need to know a simple ifs formula, by multiple condition. Please check this sheet :
https://docs.google.com/spreadsheets...nxk/edit#gid=0

Result in D5, should be 0 because If C is more than 1, then result should be 0.
I guess it's conflicted with formula for column A & B's condition, because if it's 'N' then it should be 1.

"The goal is to check if it's Y (in colomn A&B) or if it's more than 1 (in colomn C), then result should be 0

Thank You

[TMS]

Try:

Please Login or Register  to view this content.

[TMS]

Or

Please Login or Register  to view this content.

[maniacs205]

Hi

Thank you very much, it was very nice of you, but actually there are three criteria. I have added one more colomn although the result in last colomn (E) is still same.

Thank you

[AliGW]

"The goal is to check if it's Y (in colomn A&B) or if it's more than 1 (in colomn C), then result should be 0

Try this:

=IF(OR(A2="Y",B2>1),0,1)

[maniacs205]

Hi

Thank you, but di not worked, because colomn B is not a number.

[TMS]

What three conditions?

=if(B2="Y", 0, If(C2>1, 0, 1))

=ifs(B2="Y", 0, C2>1, 0, true, 1)

=if(or(B2="Y", C2>1), 0, 1)

[TMS]

Ali was replying to the original question before you restructured the worksheet.

Again, what is the third condition?

[TMS]

Is this what you want:

Please Login or Register  to view this content.

[AliGW]

There is NO worksheet ...

EDIT: It's reappeared.

[TMS]

It's a Google sheet with a link in the OP. Interesting experience as he restructured the worksheet while I was working on it.

[AliGW]

OK, well if this is a case of shifting sands, then I'll leave it be.

[TMS]

I think they're still now

Please Login or Register  to view this content.

[TMS]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[maniacs205]

Is this what you want:

Please Login or Register  to view this content.

Thank you very much it worked now

[AliGW]

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[maniacs205]

actually, the formula still did not worked well...

Please check colomn E in red

[TMS]

I think you are wrong. PICNIC.

[AliGW]

I think those sands have shifted again - column A seems to have come into play!!!

[TMS]

@Ali: the edited OP stated

The goal is to check if it's Y (in colomn A&B) or if it's more than 1 (in colomn C), then result should be 0

Post #9:

Please Login or Register  to view this content.

Post #13:

Please Login or Register  to view this content.

[AliGW]

OK - however the formula in the sheet when I looked at it did not look at column A - that was my point (perhaps poorly made).

Anyway - hope it's sorted now.

[janmorris]

it seems from your notes that your actually requirement is if A OR B is Y, then be 0...

so i propose this arrayformula:

Please Login or Register  to view this content.

[maniacs205]

It seems almost correct, but kind of messed up the sheet hence did not worked in my original source google sheet

[AliGW]

Define "kind of messed up" and "did not work".

[janmorris]

@ maniacs205

we can only make formulas based on the information you give us and in the structure you give it to us in.

so, either you give us the information we need to help you, or you find some way to modify the formulas for yourself.

[AliGW]

Sigh ...

@maniacs205

SHIFTING SANDS + VAGUE FEEDBACK = (FRUSTRATED HELPERS * WASTED TIME)

This is why I chose to step away.

[maniacs205]

Actually, let us consider it solved. Sorry for the frustration.
Just was my actual sheet needs to follow the formula.


Thank You