Multiple logic tests

Joined
Feb 3, 2015
Messages
1
Reaction score
0
Hello,

I am having a problem with the following function. I need to incorporate both situations into one function.

Situation 1

If (F) is greater than (E) and (K) is less than or equal to (E), then M=2.0 x (E - K)

Situation 2

If (F) is less than or equal to (E), then M = 2.0 x (J).

Here is what I have so far.

=IF(AND(F>E,F<=E),PRODUCT(2,SUM(E,-K)),PRODUCT(2,J))

I think I am on the right track but, this is the first time that I have used functions other than =sum and I have only learned about IF functions today. Any help would be greatly appreciated.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top