Support Board
Date/Time: Tue, 26 Nov 2024 06:53:27 +0000
Post From: How do I write spreadsheet code utalizing"IF"
| [2014-04-14 12:41:36] |
| User14682 - Posts: 83 |
|
I am interested in using "IF" to make my existing code better. Existing Buy Code: =OR(AND(AA3>AG3,AA4<AG4,AG3>AC3,AG3>AE3,AG3>AI3),AND(AA3>AI3,AA4<AI4,AI3>AC3,AI3>AE3,AI3>AG3),AND(AA3>AC3,AA4<AC4,AC3>AE3,AC3>AG3,AC3>AI3)) I would like to say If: =OR(AND(AA3>AG3,AA4<AG4,AG3>AC3,AG3>AE3,AG3>AI3),AND(AA3>AI3,AA4<AI4,AI3>AC3,AI3>AE3,AI3>AG3)) -- Buy 2 then do this: AND(AA3>AC3,AA4<AC4,AC3>AE3,AC3>AG3,AC3>AI3) -- Buy 1 Any help would be greatly appreciated Thanks!!!!!!! |