up vote -2 down vote favorite
share [g+] share [fb]

I want to compare to cell in Excel between two value and when I get smaller value then this value subtracting from third cell is it possible?

for example cell E1 Value is 961.454 And Cell E3 962.22, compare E1 And E3 i found E1 is smaller now i want E1-C4*D4 please tell me how i create whole formula 

A       B        C         D       E
963.24  1.7      65.5      0.004   961.454
964.16  1.7      0         0       962.46
963.24  1.7      60        0.004   962.22
963.4   1.7      98        0.004   961.828
963.04  1.7      80        0.004   961.508
link|improve this question
2  
Please use the "Code sample" toolbar button to format/align your table correctly in your question. – mtone Feb 5 at 5:26
1  
Syed, what you're asking isn't clear enough. You say "when I get a smaller value", not when I get the SMALLEST value. Also the relationship between the smaller value and using the next row in your calculation isn't clear and any answer you get won't assist you in this. Until you provide some additional context none of the solutions will assist you. – Jesse Feb 5 at 21:54
feedback

2 Answers

up vote 4 down vote

You can use =MIN(E1,E3) to get the minimum value between 2 or more cells {=MAX() gives you the maximum value between 2 or more cells}

You can use min in your calculations: =MIN(E1, E3) - C4 * D4.

link|improve this answer
feedback
up vote 2 down vote

The Excel function MIN() can be used to retrieve the lowest value.

=MIN(E1,E3)-C4*D4
link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.