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