Hi everyone,

Column A: (input)
Column E: (formula)
=IF(OR(B2="",C2=""),"",FLOOR(16/B2,1)*FLOOR(24/C2,1))
Column G: What I ned here is:IF Column A is less than Column E than the
figure should be taken from Column A and IF Column A is greater than
Column E than the figure should be taken from Column E.
Here is what I have for Column G that works with Column A2 , being that
the number is greater in Column A than E.

Thank you,
Craig
=(8.52*A2)/(60*60*24)


--
craigwojo
------------------------------------------------------------------------
craigwojo's Profile: http://www.excelforum.com/member.php...o&userid=13767
View this thread: http://www.excelforum.com/showthread...hreadid=273181

i don't understand your question completely but is it this you need?


IF(A1E1;A1;E1)


--
schuurke28
------------------------------------------------------------------------
schuurke28's Profile: http://www.excelforum.com/member.php...o&userid=15818
View this thread: http://www.excelforum.com/showthread...hreadid=273181