PPRuNe Forums - View Single Post - Help with Excel spreadsheet please
View Single Post
Old 12th January 2007 | 11:13
  #3 (permalink)  
gizmocat
 
Joined: May 2003
Posts: 154
Likes: 0
From: UK
You could use a nested 'if' statement. This one checks a value but doesn't multiply it. You'll get the idea though. I havn't got time to write the one you need right now, but if you PM me, I'll do it tonight. This should get you started though.
=IF(D13>201,13,IF(D13>101,15,IF(D13>51,17.5,IF(D13>1,21," "))))
Bests
Giz

Edit...OOOppss...Overcast types quicker than Gizmo
gizmocat is offline  
Reply