Spreadsheet: 138013d1327486291-cells-values-need-to-be-higher-to-right-and-below-book99
Sheet: Sheet1

 |  | 115x597 | 140x297 | 140x397 | 140x447 | 140 x 495 | 140 x 597 | 175x497 | 175x597 | 283x497 | 283 x 595 | 283x797 | 283x897 | 283x997 | 355x497 | 355x597 | 355x797 | 355x897 | 355x997 | 450x597 | 490x597 | 570 X 297 | 570x397 | 570x447 | 570x497 | 570x597 | 715x297 | 715x397 | 715x447 | 715x497 | 715x597 | 895x297 | 895x397 | 895x447 | 895x497 | 895x597
GROUP 1 |  | 9.0989325 | 7.614 | 8.235 | 8.85 | 9.45945 | 10.4286 | 19.900125 | 20.9475 | 15.9075 | 17.71497 | 19.9725 | 21.0825 | 23.205 | 17.5875 | 18.495 | 22.1025 | 24.48 | 26.9475 | 14 | 16 | 22.95 | 25.5 | 25.995 | 26.505 | 27 | 28.5 | 30 | 30.75 | 31.5 | 33 | 34.5 | 36 | 36.75 | 37.5 | 39
GROUP 2 |  | 15.5595 | 14.09925 | 14.64 | 15.195 | 15.741 | 16.764 | 21.325125 | 22.4475 | 20.4105 | 21.75525 | 28.755 | 31.932 | 35.109 | 25.91325 | 27.8025 | 34.839 | 38.691 | 42.534 | 20.05 | 22.05 | 25.17075 | 27.9675 | 30.075 | 32.19 | 34.29216 | 28.9905 | 30.78075 | 33.36 | 35.925 | 42.378 | 36 | 37.332 | 40.725 | 44.1253575 | 52.6575
GROUP 3 |  | 24.62625 | 24.79125 | 24.495 | 24.195 | 23.90025 | 25.81425 | 26.723025 | 28.1295 | 31.9095 | 33.690384 | 56.7825 | 60.2403 | 63.740475 | 33.72408 | 36.432 | 62.537025 | 64.079475 | 71.232375 | 26.623 | 28.623 | 33.5321532 | 37.257948 | 40.545 | 43.815 | 47.1021075 | 39.9182175 | 42.66675 | 44.895 | 47.124 | 55.776 | 44.991 | 51.815295 | 55.545 | 59.2869375 | 68.0295
GROUP 4 |  | 26.397 | 26.29125 | 25.98 | 25.665 | 25.347 | 28.581 | 29.2866 | 30.828 | 37.64595 | 39.959625 | 63.011625 | 65.452425 | 69.88485 | 39.726 | 44.022 | 64.037025 | 69.95265 | 77.7666 | 33.931 | 35.931 | 40.33793925 | 44.8199325 | 49.41 | 53.985 | 58.5725175 | 46.3815 | 52.49475 | 56.19 | 59.895 | 69.8643225 | 59.91975 | 62.74125 | 67.905 | 73.06929 | 84.1924125
GROUP 5 |  | 29.60925 | 27.79125 | 28.47 | 29.16 | 29.8485 | 31.9275 | 36.4077525 | 38.32395 | 44.45985 | 50.3415 | 70.673025 | 74.6139 | 86.56365 | 64.512 | 50.3415 | 87.894225 | 94.030125 | 100.115175 | 40.22245 | 42.22245 | 47.0693025 | 52.299225 | 56.715 | 61.125 | 65.5305 | 53.3247 | 62.1726 | 65.295 | 68.4285 | 82.2255 | 64.638 | 77.49 | 81.57 | 85.659 | 102.921
GROUP 6 |  | 36.7125 | 28.89975 | 31.08 | 33.255 | 35.43375 | 39.59175 | 41.648475 | 43.8405 | 47.790525 | 52.468725 | 72.234 | 80.253 | 88.281 | 66.012 | 55.401075 | 89.394225 | 97.263 | 106.983 | 45.57865 | 47.57865 | 54.536625 | 60.59625 | 65.685 | 70.785 | 75.87525 | 56.94975 | 70.198425 | 74.655 | 79.101 | 90.981 | 73.435875 | 89.3265 | 93.54 | 97.75065 | 114.1413
GROUP 7 |  | 38.2125 | 30.39975 | 32.58 | 34.755 | 36.93375 | 41.09175 | 43.28352 | 45.5616 | 65.4609 | 70.266225 | 90.453675 | 106.09005 | 107.7342 | 77.139 | 70.266225 | 112.675125 | 120.26025 | 126.87075 | 60.05395 | 62.05395 | 66.93894 | 74.3766 | 80.61 | 86.85 | 93.080925 | 70.42725 | 83.995725 | 88.935 | 93.8691 | 106.3443 | 88.250175 | 102.742425 | 107.865 | 112.9887 | 133.557525
GROUP 8 |  | 39.7125 | 31.89975 | 32.1 | 32.31 | 32.5185 | 36.5865 | 44.70852 | 47.0616 | 67.13895 | 72.062925 | 92.792775 | 107.59005 | 109.2342 | 78.639 | 72.062925 | 114.175125 | 121.76025 | 128.37075 | 61.6303 | 63.6303 | 68.662755 | 76.29195 | 82.68 | 89.055 | 95.44545 | 72.2409 | 86.1399 | 91.215 | 96.29295 | 108.742725 | 90.521475 | 104.242425 | 110.055 | 115.878675 | 136.956
This section of figures above is the actual set of figures that am working with. You'll see that there are blocks of colours. Each individual block is roughlyslightly more expensive as you go right per cell and slightly more expensive as you go down per cell. this is exactly what is needed. However there are some exceptons (f35 to f36)is one example. e35 to e36 is another. I need to apply a formula to each seperate shaded block
to make sure that those exceptions are corrected and that they are a mimimum of a whole 1.0 more than its number above and to the left. Each shaded block is not related to eachother which is why I only gave a small sample before.
The formula would have to be applied to each block as the figures will change over time as prices are manually changed at a later date on the sheets leading up to this one above.
 |  |  | Can I make this into a formula? From Cell  E5, [NAME] of cells E4 and D5 (if<=E5 then display the [NAME] figure plus 1 inE5 or in a different cell location)
 |  |  | I dont want it to change the figure unless E4 or D5 are equal to or less than E5.
 |  |  | Does this make sense?