Excel Formula Help Please

outtatune

I hope you'll take this the way it's intended; this isn't intended to be dismissive, but you don't seem to have very strong Excel skills at all. The problem with that is that if this data is business critical you really want to make sure it's being analysed/manipulated by someone who knows what they're doing, or the results could be disasterous.

Andy_L

outtatune said:

I hope you'll take this the way it's intended; this isn't intended to be dismissive, but you don't seem to have very strong Excel skills at all. The problem with that is that if this data is business critical you really want to make sure it's being analysed/manipulated by someone who knows what they're doing, or the results could be disasterous.

 "After Enron collapsed in 2001 amid an epic accounting scandal, regulators extracted a cache of half a million emails from the company’s servers. Those emails are now publicly available and have been studied by researchers trying to understand everything from the evolution of informal written language to the way people use email folders. Hermans was interested in what was attached to some of these emails: spreadsheets.

She started digging through them, not looking for fraud, but for spreadsheets with obvious errors such as missing or circular references. Looking at nearly 10,000 spreadsheets with calculations in them, she found that a quarter had at least one such error. The errors even seemed to multiply. If a spreadsheet had any mistakes at all, on average it contained more than 750."

https://timharford.com/2021/07/the-tyranny-of-spreadsheets/

Le_Kirk

Heedtheadvice said:

As Andy but you first need to decide what to do in cell G49 when G48 does not equal "Y".

You could be far better asking, given certain situations how you can achieve certain results. Though what you are doing does help understand formulae that is not always the best way of achieving an objective!

Yes, agreed; it goes IF this, then that but IF not, then something else. IF G48 = "Y", B48*C48*B1, "Error Found"