Timings, need assistance
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 |
All times are GMT +1. The time now is 11:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com