The most pointless combination of functions

[Lewiy]

If HerPatience > 1 Then Life = False

 

[kgkev]

I think it interferes with the PMT function. Excel can't cope with both.

This is just a case of calculating the week number

=if(mod(week(A1),4)=0,"PMT",if(randbetween(1,2)=1,"PMT","SAFE")

I have added an allowance for the unexpected moodswings not sure how accurate this is though.

 

[MrKowz]

This has turned into a very epic thread.

 

[Jonmo1]

=MYMOUTH=LOOKUP(PMT,{0,1},{"Open","Shut"})

 

[xyzabc198]

Actually, I wouldn’t say that was pointless at all, you are testing that a cell contains today’s date and that it is not blank. I can think of several reasons why you would want to test this condition.

As far as im aware that would check to make sure that it was greater or less than todays date and was equal to today

 

[Legacy 96851]

As far as im aware that would check to make sure that it was greater or less than todays date and was equal to today

Not sure why you think that, but try it out as a conditional format. It's a duplicate condition, because a cell that is equal to today's date is automatically not blank, and one not blank is automatically not today's date, but it still formats only cells containing the present date.

 

[xyzabc198]

Oh well...like I said, I'm new to this hehe

 

[kgkev]

I was asked to make some changes to a spreadsheet today and I found this

=SUM(E5+K5)

 

[Lewiy]

I was asked to make some changes to a spreadsheet today and I found this

=SUM(E5+K5)

It's not a useless formula in itself (I've seen this done before too), but it is a pretty pointless waste of characters, even =SUM(E5,K5) is pretty wasteful. But I guess you could keep going:

=MIN(MAX(COUNT(SUMPRODUCT(AVERAGE(SUM(E5+K5))))*(E5+K5)))

 

[Oaktree]

even =SUM(E5,K5) is pretty wasteful.

I disagree with this one. =SUM(E5,K5) is different from =E5+K5, particularly if either E5 or K5 could contain a text value.