PPRuNe Forums - View Single Post - flight times with MS Excel ... (again)

28th November 2004 | 21:22

#7 (permalink)

ZH875

Joined: Apr 2003

Posts: 2,292

Likes: 56

From: Lincolnshire

D3 [=IF(C3<7,B3,0)]

Read the formula as:

D3 =

If C3<7 is TRUE then the value of D3 is B3

if C3<7 is FALSE the Value of D3 is 0

If you left click on the = sign on the formula bar, it will open a window which explains it.