MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
=IF(G9*(I9*J9),(I9*J9),(I9*J9)*0)
I felt I had to share.
Might not be rich if you are starting with 0...
you mopping-up other people's poo again Rob?
you mopping-up other people’s poo again Rob?
Stupid is as stupid does 🙂
Plenty of the original figures are zero - the fail is quite strong round here.
I think a training session may be in order...
P.S.
The column header for this wonder is: Efficiency
Laugh? I nearly did!
surely the first * should actually be an =
???
#VALUE!
think i broke something
ps. anything multiplied by zero is zero
surely the first * should actually be an =
Returns 0 for all of these figures 😀 😀
It actually gives the right answer as is, but is done in what I would call the worng way.
ps. anything multiplied by zero is zero
∞*0 != 0
Put an iferror at the start and its better.
=iferror(IF(G9*(I9*J9),(I9*J9),(I9*J9)*0),"Review") or if you do not want to review.
=iferror(IF(G9*(I9*J9),(I9*J9),(I9*J9)*0),"")
It makes no sense.
Youre saying: “if G9 x I9 x J9 then I9 * J9 else I9 x J9 x 0
Which is obviously total gibberish.
So did you write this formula, or encounter it somewhere? This thread has failed to deliver on so many levels.
i understood zero factorial was generally held to be 1?
This thread has failed to deliver on so many levels
You came to this thread with expectations of anything else?
Well it’s a very simple, shit formula which makes no sense.
I had higher expectations.
total crap.
Ban please
You humourless ****ers!
It makes no sense.
This was rather the point, my dear NG. If you can figure that out you can probly figure out if I wrote it or not*
*A clue: I didn't.
I'm not clever enough for this
when you say it actually does what it's supposed to do, what is it supposed to do ?
since there's no =, <, >, is it just assuming that G*I*J has to not be zero in order to progress to the "correct" side of the IF
<tests for self>
<agrees with self>
<proud of self>
I thought the formula might be (okay, hoping) something rude. Like entering 55378008 on a calculator and turning it upside down.
when you say it actually does what it’s supposed to do, what is it supposed to do ?
=I9*J9 does the job.
No IF() is required as it always resolves to true. WTF was going through the mind of the guy who wrote it, I cannot fathom.
He's also in the habit of doing this kind of thing:
=+A1+A2
I'll be having words.
seems to me that it returns I9xJ9 only if G9 is NOT zero
If G9 is zero it returns zero - maybe for a good reason
presumably G9 can't just be 1 or 0, or they'd just make it =GxIxJ
Reported. For claiming he got the best excel than the excel that I got.
Does no-one report spammers any more? C'mon guys, help us out here.
I did. What do I win?