![]() |
|
#4
|
||||
|
||||
|
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] |
|
|
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 |