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