Re: If then Statements

In article <ee98dcc.-1@xxxxxxxxxxxxxxxxxxxxxxx>,
lauren@xxxxxxxxxxxxxxxx wrote:

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

--
Team EM to the rescue! http://www.team-em.com
.

Relevant Pages
Loading