#1
|
|||
|
|||
Insert cap figure instead of sum
now I have that working trying another formula
I have two cell working with previous formula with the 2 amounts capped. I then want a total of the 2 amounts but if both cells have been capped I want the cap figure and not the SUM of the 2 cells. I currently have this =SUM(T9,W9) and tried this =SUM(T9,W9,J9) but with this it caps all and doesn't add the 2 cells when needed. any ideas please Edit mod : this post is related to https://www.msofficeforums.com/excel...l-formula.html Last edited by Pecoflyer; 08-01-2018 at 07:29 AM. |
#2
|
||||
|
||||
Which of the capped amounts would be the result?
Post a small sample sheet with some data and expected results ( click Go advanced - Manage attachments)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
the capped figure would be the J9 cell
|
#4
|
||||
|
||||
Add an example as requested please
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
please help
|
#6
|
||||
|
||||
Perhaps =MIN(L7+O7,C7) ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
This works OK but if a cell in the calculation L7+O7 is blank it returns #value??
I still want it to return the value of cell C7 Last edited by Pecoflyer; 08-10-2018 at 08:11 AM. |
#8
|
||||
|
||||
What about?
=MIN(C7,SUM(L7,O7)) |
#9
|
|||
|
|||
NBVC Brilliant - works well thank you
|
#10
|
||||
|
||||
Quote:
If it returns a VALUE error, it is not blank but contains the empty text string ""
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#11
|
|||
|
|||
Looking some help.
I am looking column N to be Column J * M, if more than column B enter column B's value minus column L. In red what is should be. ABCDEFGHIJKLMNOP30/01/201850.00YES11.1yes06/03/201822/05/201850.00£1.0026£26.0056£56.00 (£24.00)82£50.00 |
#12
|
||||
|
||||
Try:
=IF(J2*M2>B2,B2-L2,J2*M2) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Figure number cross-referencing mess; figure numbers not updating. | seanspotatobusiness | Word | 25 | 08-06-2018 05:00 PM |
VBA to find any nine-figure number | Chayes | Word VBA | 2 | 05-19-2017 06:06 AM |
Trying to figure out this code | sharpied | Word | 0 | 07-27-2016 12:09 PM |
Caption Order: Figure 4 Figure 3 Figure 2 | golfarchitect13 | Word | 5 | 05-07-2014 07:15 PM |
Convert "Figure", "Figure", "Figure" to "Figure1", "Figure2", etc. | altjx | Word | 4 | 06-04-2013 05:29 AM |