× Auto Repair Pros Member Benefits TechHelp Knowledge Base Forums Resources My iATN Marketplace Chat Pricing About Us Join Industry Sponsors Video Members Only Repair Shops Auto Pro Careers Auto Pro Reviews
Join Now
International Automotive Technicians Network
Re: Excel 'if' 'then' equations
Posted to PC Users Forum on 1/30/2009 2 Replies

[...trimmed text...]

=IF(A1 < Y1, A1/0.7, IF(A1 > X1, A1/0.8, A1/0.75))

That works in the version of Excel I have access to. It is the same as the OpenOffice, except Excel appears to use a comma as a delimiter, where a... Login to read more.

2 Replies Received (View Replies)