Formula

V

Val

Formula in C3 is =IF(E3>D3/12,E3,D3/12).

I would like to have the cell (d3 or e3) where the data entered last control
the answer in c3.
 
C

CLR

Put this in C3 instead.....

=IF(COUNT(D3:E3)=2,IF(E3>D3/12,E3,D3/12),"")

Vaya con Dios,
Chuck, CABGx3
 

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

Similar Threads

Fill cells based on the other 3 cells unique combination the value on the target cell 0
Brain fart in simple subtraction 2
Supress DIV/0 2
help pence to pounds with formula 2
If Condition 4
Multiple IF conditions 3
Help with formula 4
Return error #VALUE! 1

Top