View Single Post
 
Old 01-07-2021, 07:17 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,816
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote