Still Can't Figure Out If Statement For Errors

Status
Not open for further replies.

lmarkowi

New Member
Joined
Apr 5, 2006
Messages
29
I am still having a problem figuring out how to identify when a value is greater than the value that comes before it, even if it is seperated by a few lines of errors. A sample of my data is below...if anyone can help please respond. Thanks! If possible, I would like to quantify the difference if a value on a later date is More than the value before it. If anyone needs more detail just say so. Thanks for all of your help. I have changed the errors to "NV" for ease.


5,745,063,946.30
7,068,203,722.46 ---True (or 2 billion and change)
5,602,064,833.27 False
NV
5,558,266,489.90 False
NV
5,138,950,142.83 False
NV
5,108,390,612.39 False
NV
NV
5,100,738,239.95 False
NV
4,761,400,527.68 False
NV
4,770,628,041.00 True
NV
NV
4,626,463,143.05 False
NV
NV
4,508,925,824.15False
NV
NV
4,472,536,354.04 False
NV
NV
4,425,447,546.19False
NV
NV
4,402,019,115.39 False
NV
NV
5,370,318,730.06 True
NV
NV
4,479,014,609.69
NV
NV
4,311,827,343.41
NV
NV
4,281,670,929.13
NV
NV
4,270,949,823.35
NV
NV
4,251,292,284.34
NV
NV
4,216,032,751.97
NV
NV
NV
4,205,580,854.82
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,111,598
Messages
5,541,163
Members
410,543
Latest member
ExcelGlenn
Top