If Formula Unparsable

AnnieR

Would anyone be able to help see what's wrong with this formula? I'm not sure how I'm screwing this up..

My formula works like this but if the status is anything other than partial I'd like the cell to say "N/A"

=IF(Status@row = "Partial", QTY@row) - [Received Quantity]@row

So I just tried this:

=IF(Status@row = "Partial", QTY@row, "N/A") - [Received Quantity]@row

Ideally I'd like the formula to spit out the QTY column value if the status says anything other than Partial or Received.

Jeff Reisman

@AnnieR Since you've given conflicting criteria,

(if the status is anything other than partial I'd like the cell to say "N/A")

(I'd like the formula to spit out the QTY column value if the status says anything other than Partial or Received.)

I just went with what I think you want to achieve.

=IF(OR(Status@row = "Partial", Status@row = "Received"), QTY@row - [Received Quantity]@row, "NA")

This says, if the Status is "Partial" or "Received", give me the QTY from this row minus the Received Quantity from this row; otherwise, just give me "N/A".

Kelly Drake

I'm thinking the " - [Received Quantity]@row" part of the formula is what's throwing this.

I would try this...

=IF(OR(Status@row = "Partial", Status@row = "Received"), QTY@row - [Received Quantity]@row, QTY@row)

This assumes you have columns named Status, QTY, Received Quantity exactly.

Jeff Reisman

@AnnieR Since you've given conflicting criteria,

(if the status is anything other than partial I'd like the cell to say "N/A")

(I'd like the formula to spit out the QTY column value if the status says anything other than Partial or Received.)

I just went with what I think you want to achieve.

=IF(OR(Status@row = "Partial", Status@row = "Received"), QTY@row - [Received Quantity]@row, "NA")

This says, if the Status is "Partial" or "Received", give me the QTY from this row minus the Received Quantity from this row; otherwise, just give me "N/A".

AnnieR

Thank you @Kelly Drake and @Jeff Reisman this was really helpful and I'm sorry for my incomplete question :)