![]() |
|
|
|
#1
|
||||
|
||||
|
To be able to refer to the bookmark directly, you'd need to ensure it doesn't include the end-of-cell marker. See the Testing and Returning Cell Contents in Tables topic for an explanation.
As for the syntax, it should be: {IF{REF Ship}= "Free" "NA" {=IF(C7<200,4.95,{=IF(C7<500,7.95,10.95)})}} Note the required spaces.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#2
|
|||
|
|||
|
Nothing I did worked. Used the format you suggested and it returned "0". Made a few modifications, never did anything except returning zero.
So rather than keep pursuing that I decided to merge the tables so I did not have to refer to a cell outside the table. Tried to use- {=if(d2="Free","NA",if(c10>499.99,10.95,IF(c10>199 .99,7.95,4.95)))} Where d2 was the cell with the shipping drop down menu. Syntax error. No amount of playing with the format worked as expected. I tried to use the tag as a label (the content control has the tag "Shipping"), it didn't help. {=if({Shipping}= "Free" "NA" {if(c10<200,4.95,{=if(c10<500,7.95,10.95)})}} This formula doesn't show anything as a result, but at least it is not a syntax error. I added a bookmark to the cell d2 (Ship) {if({Ship}= "Free" "NA" {if(c10<200,4.95,{=if(c10<500,7.95,10.95)})}} Syntax error. {if({ref Ship}= "Free" "NA" {if(c10<200,4.95,{=if(c10<500,7.95,10.95)})}} Syntax error. I can bookmark the whole cell but I can't bookmark just the controlled content part, it is greyed out when I click "Insert bookmark" (with the dropdown box selected). I must be making a fundamental mistake but can't figure out what it is. Also when I am reading your tutorial document it comes up as Compatibility mode for me and all the internal links do not function. Also the MS KB211253 linked in the doc is no longer available. Please help, I'm really not grokking this. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Formula for Cross Referencing Numbered List
|
hiwire03 | Word | 9 | 08-09-2020 12:01 PM |
| Referencing Entire Columns in Excel Formula w/ Conditional Fomating | OldIronBoots | Excel | 1 | 06-18-2018 03:42 AM |
NEED: Formula for referencing data in two files
|
ross.lowe | Excel | 1 | 02-21-2017 09:34 AM |
| Naming Cells for formula referencing | lynchbro | Excel | 6 | 06-26-2014 07:45 AM |
| Referencing a value over 255 characters within a table PLUS strange formula behaviour | TishyMouse | Excel | 2 | 01-08-2013 09:39 AM |