I created a spreadsheet to calculate property "Return on Investments" (ROI). I then added a column with the If command. Here is an example formula:
=IF(AND(G12>=G4; G12>=G5; G12>=G6; G12>=G7; G12>=G8; G12>=G9; G12>=G10; G12>=G11; G12>=G13; G12>=G14; G12>=G15; G12>=G16; G12>=G17; G12>=G18; G12>=G19; G12>=G20; G12>=G21; G12>=G22; G12>=G23; G12>=G24; G12>=G25; G12>=G26; G12>=G27; G12>=G28);"Buy!!";"--")
I dont know if it matters but the ROI is a very small decimal percent. However I found that when 2 properties get close the "Buy!" symbol dissapears from all cells. I have compared all the formulas and found no issues.
I have attached the file to this post
The issue occurs when 1750 is but in cell B12. I have narrowed the issue to cells A6 and A10.
Here are the formulas involved :
=IF(AND(G6>=G4; G6>=G5; G6>=G7; G6>=G8; G6>=G9; G6>=G10; G6>=G11; G6>=G12; G6>=G13; G6>=G14; G6>=G15; G6>=G16; G6>=G17; G6>=G18; G6>=G19; G6>=G20; G6>=G21; G6>=G22; G6>=G23; G6>=G24; G6>=G25; G6>=G26; G6>=G27; G6>=G28); "Buy!!"; "--")
=IF(AND(G10>=G4; G10>=G5; G10>=G6; G10>=G7; G10>=G8; G10>=G9; G10>=G11; G10>=G12; G10>=G13; G10>=G14; G10>=G15; G10>=G16; G10>=G17; G10>=G18; G10>=G19; G10>=G20; G10>=G21; G10>=G22; G10>=G23; G10>=G24; G10>=G25; G10>=G26; G10>=G27; G10>=G28); "Buy!!"; "--")
Can this be a precision issue? Any help is appreciated
Bookmarks