Forum Discussion
nvconstruction2
Feb 12, 2018Copper Contributor
Need help with formula
Hi all.
I have been trying to create a formula for the issue below but to no success. Please coukd someone give me an idea of what formula to use. If A1 = 0,12,18,21 and A2 = 1,2,3,4,SR,HR and A3 = 3, 3.5, 4 then A4 = x (Predetermined figure).
I have been trying to create a formula for the issue below but to no success. Please coukd someone give me an idea of what formula to use. If A1 = 0,12,18,21 and A2 = 1,2,3,4,SR,HR and A3 = 3, 3.5, 4 then A4 = x (Predetermined figure).
That could be like
=IF(SUM(--(A1={0,12,18,21}))*SUM(--(A2={1,2,3,4,"SR","HR"}))*SUM(--(A3={3,3.5,4})),"x","")
for A4 if you mean OR condition for values to check with A1, A2, A3
- nvconstruction2Copper ContributorHi Sergei.
Thank you for you're response. I have tried the formula that you sent me but it is not working. I have attached a spreadsheet of the values I'm working with.
If i change the values in columns A B and C then i need the value in column E to correspond to what is in there at the moment.
You're help would be greatly appreciated.
Best regardsHi,
Do you mean values in column E are predefined? If, for example, you enter somewhere in 3 cells values 6, 2 and 3 the result in fourth cell shall be picked-up from E and equal to 6448?