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.
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.