View Single Post
 
Old 09-03-2023, 04:59 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

The formula in column F refers to a named range GlucoseFactor. There are in fact 2 such named ranges, one Workbook-scoped and one Sheet-scoped. One refers to:
='Glucose Factor'!$A$2:$B$29
the other to:
='Glucose Factor'!$A$2:$B$32
I suggest you change the formula to:
=IF([@Libre]=0,[@Blood], IF([@Libre]>0,[@Libre]*VLOOKUP([@Date],Table4,2),0))
Reply With Quote