if forumula

  1. A

    SUM formulas with exceptions

    I'm trying to write a formula that will add "500" to the adjacent cell quantity, like this =IF(D3:D100>0,D3:D100+500,"") It's working but I'm getting an error. Please help!
  2. R

    identify time zone by looking at area code

    I have a column full of phone numbers. I would like to be able to denote what time zone each number is in, in a separate column for each corresponding row. How can I do this? I would imagine the formula would look at the first 3 digits for each number and then be able to identify what time...

Some videos you may like

This Week's Hot Topics