Trouble thinking of a simple formula solution for complicated review

[rando123]

Hello

Hoping someone can help me come up with a formula for the column Discrepancy Under Threshold or confirm it's not even possible. I have been trying to come up with one but struggling. A simplified table is below.

Logic explained in words of what I need:
If Dropdown Category cell does not equal "Discrepancy under Threshold" return 0.
If Dropdown Category DOES equal "Discrepancy under Threshold" AND New Amount is NOT blank, return cell from New Discrepancy column.
If Dropdown Category DOES equal "Discrepancy under Threshold" AND New Amount is blank, return cell from Original Discrepancy column.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Original Amount[/TD]
[TD]Original Discrepancy[/TD]
[TD]New Amount (optional)[/TD]
[TD]New Discrepancy[/TD]
[TD]Dropdown Category[/TD]
[TD]Discrepancy Under Threshold[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Formula here[/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Assuming the header row begins in A1, enter in F2 and copy down:

=IF(E2<>"Discrepancy under Threshold",0,IF(AND(E2="Discrepancy under Threshold",NOT(ISBLANK(C2))),D2,IF(AND(E2="Discrepancy under Threshold",ISBLANK(C2)),B2,"")))

 

[rando123]

Thanks! It worked out perfect

 

[JoeMo]

Thanks! It worked out perfect

You are welcome - thanks for the reply.