Timings, need assistance

C

craigwojo

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 th
figure should be taken from Column A and IF Column A is greater tha
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 tha
the number is greater in Column A than E.

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

schuurke28

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


IF(A1>E1;A1;E1
 

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

Help needed regarding calculating time 0
Needing help with a Function on Excel. 2
series of formulas to get to one formula 0
conditional formatting 3
I Need Calculate Variable Scenarios with timings 0
conditionals statements 10
conditional statement =IF(A1<B1,"<",IF(A1=B1,"=",">")) <--- don't 1
VBA "Find" with multiple criterion 11

Top