If then Statements

[lauren]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I think I need an IF/Then statement that calculates a formula if the value is another colum is 'X'. Specifically:

If H6="Smith" then J6=sum(I6/2)
If not then J6=I6

I've tried:
Conditional formatting
Function/IF
Calculator

Must be something, but I'm stumped. If it requires VBA, I do still have Excel 2004, but it's a pain to switch back and forth.

Thanks so!

 

[JE McGimpsey]

Must be something, but I'm stumped. If it requires VBA, I do still have Excel
2004, but it's a pain to switch back and forth.

Just as in XL04, highlight color is taken from the system preferences.

Open System Preferences from the Apple menu, choose the Appearance Pane,
and choose (or create, using "Other") your preferred color in the
Highlight Color dropdown. Close (if necessary) and reopen XL.

Note that this color will then apply system wide.

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I think I need an IF/Then statement that calculates a formula if the value is
another colum is 'X'. Specifically:

If H6="Smith" then J6=sum(I6/2)
If not then J6=I6

I've tried:
Conditional formatting
Function/IF
Calculator

Must be something, but I'm stumped. If it requires VBA, I do still have Excel
2004, but it's a pain to switch back and forth.

Thanks so!

I'm missing something here: the structure of the function is:


IF( [evaluation],[value if true],[value if false])

So can't you just type

IF(H6="Smith",I6/2,I6) ?

BTW, what did you mean by "sum(I6/2)" ? no need to use 'sum' for a
single element

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I think I need an IF/Then statement that calculates a formula if the value is
another colum is 'X'. Specifically:

If H6="Smith" then J6=sum(I6/2)
If not then J6=I6

I've tried:
Conditional formatting
Function/IF
Calculator

Must be something, but I'm stumped. If it requires VBA, I do still have Excel
2004, but it's a pain to switch back and forth.

Thanks so!

Lauren,
A formula can only affect the value of the cell that contains it. A formula
can NOT change the value of another cell. So, put this formula in J6:
=if(H6="Smith",i6/2,i6)

 

[lauren]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I think I need an IF/Then statement that calculates a formula if the value is
another colum is 'X'. Specifically:

If H6="Smith" then J6=sum(I6/2)
If not then J6=I6

I've tried:
Conditional formatting
Function/IF
Calculator

Must be something, but I'm stumped. If it requires VBA, I do still have Excel
2004, but it's a pain to switch back and forth.

Thanks so!

Lauren,
A formula can only affect the value of the cell that contains it. A formula
can NOT change the value of another cell. So, put this formula in J6:
=if(H6="Smith",i6/2,i6)
[/QUOTE]

Thank you SO! Obviously basic Excel and I was trying to make it hard!

Happy day and, thanks, again.

Lauren