CREATE AND IF FORMULAS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to make a fromula conditional on at least one cell containg a value (not blank 1
Checking for black cells 3
sum of range containing formula in blanks 1
attendance based pay for Army reserve 3
Function help! 1
SUMIF Problem 1
Conditional format (word change) 2
Conditional Formatting using two formula conditions 1

Back
Top