FlyerTalk Forums - View Single Post - MS Excel Help
Thread: MS Excel Help
View Single Post
Old May 23, 2006 | 8:32 pm
  #32  
sadiqhassan
10 Countries Visited
All eyes on you!
20 Years on Site
 
Join Date: Jan 2005
Location: Pennsylvania
Programs: AA Platinum Pro, AC *S, Marriott Gold Elite, Hyatt Explorist
Posts: 9,791
Originally Posted by Efrem

2) Enter formulas like these into the two conditional destination cells:

=if(third cell > 100,first cell,"")
=if(third cell > 100,second cell,"")

The "" puts a null text string (i.e., nothing at all) in the destination cells if the condition in the IF function is not satisfied.
would it be possible to do this with times?

For example:

if time in third cell > 2:00pm?

Thanks again,
sadiqhassan is offline  
Reply