Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 02:29 PM
craigwojo
 
Posts: n/a
Default 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


  #2   Report Post  
Old October 28th 04, 03:01 PM
schuurke28
 
Posts: n/a
Default


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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
New user in need of assistance excel pop-ups, forms, +more!! Ken Macksey New Users to Excel 4 January 15th 05 03:18 PM
Drop Down Help Assistance is very confusing. Can someone help me. Erin Excel Discussion (Misc queries) 1 January 7th 05 03:24 PM
How do I display daily duty timings (day/night) of employees for . R. Bhan Excel Discussion (Misc queries) 0 December 18th 04 11:33 PM
Turn off Assistance pane in Excel Petra Excel Discussion (Misc queries) 1 December 1st 04 02:19 AM
To me this is huge, need some assistance craigwojo Excel Worksheet Functions 0 October 27th 04 05:52 PM


All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017