CREATE AND IF FORMULAS

F

fyrefox

How do i create a formula like this
=SUM((AE3={"O","1","2","3"})*{empty,30,60,90})
The final format I want to accomplish is: AD=AA3+AE3 where AE3 is empty
leave AD3 empty
 
F

fyrefox

Thanks Kassie this worked great now if I can fugure out how to keep the
formula from getting deleted from different users it would be great.
Firefighters in Iraq can mess up anything.
 
Top