Quote:
Originally Posted by Pecoflyer
A bit shorter
Code:
=IF(OR(C3={"2x","3x","4x","5x"}), 45, IF(LEFT(C3,1)="Y", 30, IF(ISBLANK(C3), "", 40)))
(array delimiters might vary depending on regional settings)
BTA a small sample sheet with some desensitized data and expected results would help |
Sure could have used this but with my longer formula I got the task achieved. Thanks for everyone who helped, I really appreciate your assistance.