The above formula looks like this with all the values from the referanced cells data in it.
Formula:
=IF(G5=1,
IF(AND((C4-D4)/ABS(D4)>5%,(C4-D4)/ABS(D4)<21%,(E4-B4)/ABS(B4)>-20%,(E4-B4)/ABS(B4)<5%,(E4-D4)/ABS(D4)>-6%,(E4-D4)/ABS(D4)<13%,(C4-D4)/ABS(D4)>-6%,(C4-D4)/ABS(D4)<19%,(C5-D5)/ABS(D5)>5%,(C5-D5)/ABS(D5)<14%,(E5-B5)/ABS(B5)>4%,(E5-B5)/ABS(B5)<8%,(E5-D5)/ABS(D5)>5%,(E5-D5)/ABS(D5)<14%,(C5-D5)/ABS(D5)>5%,(C5-D5)/ABS(D5)<14%),"Call Sparky","")
I thought; & I could be mistaken, that we could highlight a cell ref & use some keyboard shortcut to convert the ref to values in the formula. I am probably confused, but throwing it out there none the less
Thx Pete
Bookmarks