Incomplete formula for if

Our take

Hello everyone! It seems you're facing challenges with your formula for conditional checks based on the status of various accounts. Your goal is to differentiate between actions required for "billed" and "unbilled" statuses across different categories. The current formula appears to miss some key conditions and may not correctly apply the logic for all specified accounts. Let's explore a refined approach that clearly articulates these conditions while ensuring clarity. This way, you can confidently develop your skills in creating effective formulas.

Hello everyone.

There is wrong with my formula. Here is the context

If the AP.Internal is "billed" equals to recheck the monitoring

But

If the AP.Internal is "unbilled" equals to recheck the monitoring

This condition is same with AP.RAW MATERIALS, AP.Overhead,AP.INVESTOR that if it's billed equals to for managers approval but if not recheck the monitoring

But for AP.Supplies, AP.third party, AP.Fees, OT external audit regardless of the status. It should return as "do sanity check"

My formula was:

If(and(c2="ap.internal",d2="billed"),"for managers approval","recheck the monitoring"),if(and(c2="AP.Supplies, AP.third party, AP.Fees, OT external audit"),"do sanity check","")

Before coming up with the formula. I tried to use it works

If(and(c2="ap.internal",d2="billed"),"for managers approval","recheck the monitoring")

There is something wrong with my formula. I'm not sure if the if formula is most suitable or should be xlookup?

Thank you for helping me. But kindly explain to me how can I like understand how do you come up with the correct one. I'm trying to learn be independent working on formulas.

submitted by /u/Ok_Vacation_7897
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#AI formula generation techniques#generative AI for data analysis#formula generator#financial modeling with spreadsheets#rows.com#Excel compatibility#Excel alternatives#AP.Internal#formula#billed#unbilled#for managers approval#recheck the monitoring#monitoring#sanity check#AP.RAW MATERIALS#AP.Overhead#AP.INVESTOR