Returning a value of 1 of 3 cells
I have 3 columns. [REQ Amount], [PO Amount], [INV Amount]. I want another column [Amount] to be the most relevant "amount" . At first a REQ is done for say $2. Then a PO is sent for the said REQ but gets messed up and issued for say $3, then my actual cost might be $3. Then the invoice comes in at $2. So when the invoice is paid, I want the $2 to be my most relevant expense amount.
How do I write a statement that says if INV Amount and PO Amount are Null, then REQ Amount, Else if INV Amount is Null then PO Amount, else, INV Amount?
Thoughts?
Best Answer
-
Good Afternoon,
I want through your scenario above and believe an IF statement formula would solve your most relevant "amount" column.
This is the formula I wrote and the scenarios I tested are blow.
=IF([INV Amount]@row = [PO Amount]@row, [REQ Amount]@row, [INV Amount]@row)
Please let me know if this helped!
Answers
-
Good Afternoon,
I want through your scenario above and believe an IF statement formula would solve your most relevant "amount" column.
This is the formula I wrote and the scenarios I tested are blow.
=IF([INV Amount]@row = [PO Amount]@row, [REQ Amount]@row, [INV Amount]@row)
Please let me know if this helped!
-
Hi Kayla, good afternoon to you as well. This kinda works. In the end, the most relevant number is the later one in the process. So I'm encumbering with a REQ $2 from a budget, until a PO is done, then the $2 is superseded by a $3 PO... until an invoice is received then the INV $2 supersedes the PO. Does that make more sense?
-
EUREKA.. i GOT IT! Thanks for the insights!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!