Quote (Shadow_Nzl @ 7 Sep 2010 15:59)
I need help.
I'm trying to do formula's in Excel
I want a value to be displayed if one cell is bigger than two others, if it's not, I want it to display a word
I'm fairly sure this should work. =IF(D3>D4:D5,D3,"Winner A")
as in, if D3 is greater than D4 and D5 display the value in D3, if not display "Winner A"
but it's being a cunt and keeps coming up with #VALUE! error
u want winner if d3 is > d4+d5? or d3 > either d3 or d4?
Quote (Shadow_Nzl @ 7 Sep 2010 16:33)
Got it, was missing OR in there

yep thats what i wanted to suggest u
This post was edited by Stingray14k on Sep 7 2010 08:33am