On May 5, 10:53*am, "Rick Rothstein \(MVP - VB\)"
wrote:
Yeah, that works with simple numbers, but when B1 is a result,
such as C3+C4, I get invalid TRUE/FALSE returns.

Can you show us an example of that (showing us the values you have in each
of the cells)?

Rick

Sure, but it gets a bit lengthy because A1 and C1 are links to a live
feed data source (Galaxc) and B1 is the result of multiple links.

Again, I'm looking for A1<B1<C1, either TRUE or FALSE, whe

A1: =RTD("Galaxc.RTD","",A10,"buy","price")
B1: =D5+D6
C1: =RTD("Galaxc.RTD","",A10,"sell","price")

D5: =RTD("Galaxc.RTD","",A10,"settlement")
D6: =E10+E11
E11: =IF(G10=TRUE,H10,J10)
E12: =RTD("Galaxc.RTD","",A12,"sell","price")
G10: =IF(RIGHT(F10,1) = "0", TRUE, FALSE)
H10: =IF(G10=TRUE, (E10+C10)/2, "bid/ask")
J10: =IF(I10<B10, I10+2.5, I10-2.5)