Excel formula will not work 2

[junior1r]

Hi this formula will not work can you tell me why
=IF((C#<E#),C#)&IF((C#>D#),D#)&THEN((B#*.03)+(C#-(B#*.03))/2)

key
# Number
* Multiply

Regards

Junior1r

 

[dianemarie]

Hello Junior, where to start...

The ampersand (&) means concatenate, is that what you are trying to do? It looks like you are doing an If Then Else formula. (Then by itself is not a function I'm aware of.) Why don't you put in english what you are trying to do? There are numerous people on this site who can give you the correct formula, but I don't think what you gave us is very clear.

 

[Zathras]

I can't tell what you're trying to do either, but perhaps you mean something like this(?):
[blue]

  =IF(C2<E2,C2,IF(C2>D2,D2,((B2*0.03)+(C2-(B2*0.03))/2)))

[/color]

 

[mikevh]

I'm guessing that what you want to say is

if c < e
c
else if c > d
d
else
(your expression)

If so, I think the following will do it:

=IF(C1<E1,C1, IF(C1>D1,D1,(B1*0.03)+(C1-(B1*0.03))/2))