1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Incomplete formula for if

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]

Want to read more?

Check out the full article on the original site

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