Current Position:Home > Using excel formulas to circumvent non-existence of data

Using excel formulas to circumvent non-existence of data

Update:11-30Source: network consolidation
Advertisement
Hello,
If there is no data in my database for a particular month my query retrieves nothing. Accordingly I would like to insert an excel formula in the spread sheet saying something like "If cell is blank then insert next month name"
Is there a way of excel knowing what the next month name is (for example: what comes after APRIL)? Can I create a list of values in excel to tell it what month comes next?
Example:
APRIL - $100
MAY - $100
NOVEMBER - $100
I would like to insert all the months between May and November
Thanks in advance.

The Best Answer

Advertisement
Hi Alicia,
It can be done. Have the months from Jan to Dec hardcoded. And write a formula saying
=if(<value Cell>="",<corresponding cell having the next month>,<cell having the same next month>)
I hope it solves the issue.
It can be clearer if you explain the scenario, that way it would be easy to solve.
Thanks,
Sara
  • Using excel formulas to circumvent non-existence of data Update:11-30

    Hello, If there is no data in my database for a particular month my query retrieves nothing. Accordingly I would like to insert an excel formula in the spread sheet saying something like "If cell is blank then insert next month name" Is there a

  • How to convert an Excel Formula to a Custom Calculation Script in a Adobe Acrobat 9 Form? Update:10-11

    Hello, I am not familiar whatsoever with Javascript and need some help in converting the following Excel Formula so that I can enter it into a Custom Calculation Script in a Adobe PDF Form. Here is the formula: =IF(E15<25.01,9.95,IF(E15<50.01,11.95,

  • How to use Excell formula's within EVDRE Update:10-11

    Hi, we want to built a rather large P&L with time in columns and account and cost center in the rows. We would like to insert some subtotals within the P&L strucure using simple excel formula's. So we create the P&L structure and leave some em

  • SAP BPC 10.0 NW - Delete excel formulas Update:10-11

    Hello Experts, I have both "Keep formula on data" chekboxes selected (inside Edit Report and inside Sheet Options) and in my computer when I refresh the workbook the formulas are not deleted, but in other computers, also with the same version of

  • Numbers Equivalent of Excel Formula for Converting HH:MM:SS to DD:HH:MM:SS Update:11-30

    I am not sure if this has been asked before. What would be the Numbers formula for converting HH:MM:SS to DD:HH:MM:SS?  The Excel formula is entering 396:59:45 into a cell and then in another cell is the following =TEXT(A2,"dd:hh:mm:ss").  The A

  • Use of Excel Formulas in EVDRE reports Update:11-30

    Dear Freinds, I am trying to use excel formulas in EVDER (report).                                                   2011.MAR Account(Base level member)  =SUM(RANGE) this at somepaces is working and in some places its  not working. Kindly share the k

  • EvDRE - SortRange - AfterRange - Copy Excel formula Update:11-30

    Hi all, In BPC NW 7.5 SP04 I have performed the following actions: I have sorted the EvDRE based on some column and added an AfterRange parameter. In the AfterRange cells I have entered various Excel formulas as well as evsub. The system would copy t

  • Retrieving BEx Query Results Area for use in Excel formulas Update:11-30

    Hello, I run BEx queries in workbooks and then use Excel formulas ( mostly VLOOKUP(LookupValue, ResultsArea, ColumnReturned,) ) to retrieve certain information from the query ResultsArea. ****Problem: Depending on the query parameters, the query "Res

  • How do you display excel formulas? Update:11-30

    How do you display EXCEL formulas in Numbers once imported?select the cell and look at the bottom of the window or doubel click the cell: after double clicking cell:Read other 2 answers

  • Convert mathematical formulat to excel formula Update:11-30

    I have a formula that was generated by excel when using a trendline on a graph. I need to convert this formula into an excel formula I can use again. the formula is below. Assume that the value for X will be in Cell A1. Any help converting this to an