8 Aug 2010 at 22:00 #1 campbell campbell Associate Joined 26 Aug 2009 Posts 602 Location Up the tree I've been all over the net and can find a solution. Ahhh!!! Basically what i want to say is the following: If Cell E4 is => 15 then add 0.5 Thats what i want. Can anyone help?
I've been all over the net and can find a solution. Ahhh!!! Basically what i want to say is the following: If Cell E4 is => 15 then add 0.5 Thats what i want. Can anyone help?
8 Aug 2010 at 22:03 #2 Makhaira Makhaira Soldato Joined 23 Nov 2007 Posts 4,994 Location Lancashire, UK You might want to check the syntax of the IF command, since I'm doing this without actually being in Excel... =IF(E4=>15,E4+0.5,) I might have the TRUE and FALSE conditions the wrong way around in there.
You might want to check the syntax of the IF command, since I'm doing this without actually being in Excel... =IF(E4=>15,E4+0.5,) I might have the TRUE and FALSE conditions the wrong way around in there.
8 Aug 2010 at 22:03 #3 campbell campbell Associate OP Joined 26 Aug 2009 Posts 602 Location Up the tree Thanks Dude, ill try.
8 Aug 2010 at 22:06 #4 campbell campbell Associate OP Joined 26 Aug 2009 Posts 602 Location Up the tree Makhaira said: You might want to check the syntax of the IF command, since I'm doing this without actually being in Excel... =IF(E4=>15,E4+0.5,) I might have the TRUE and FALSE conditions the wrong way around in there. Click to expand... Awesome dude it worked great. Had to switch around the > & = symbol though. Thank you so much.
Makhaira said: You might want to check the syntax of the IF command, since I'm doing this without actually being in Excel... =IF(E4=>15,E4+0.5,) I might have the TRUE and FALSE conditions the wrong way around in there. Click to expand... Awesome dude it worked great. Had to switch around the > & = symbol though. Thank you so much.
8 Aug 2010 at 22:16 #5 Makhaira Makhaira Soldato Joined 23 Nov 2007 Posts 4,994 Location Lancashire, UK Glad you got it sorted
