User Profile
pebbles1221
Copper Contributor
Joined Aug 19, 2019
User Widgets
Recent Discussions
Help with Formulae IF statements
Please could someone help me with concatenate IF statements. E4 = 160 E5 = 149 B10 = 137 If E4 is greater than B10, give me E5 x 2 /100 or if E4 is less than or equal to B10, give me E5 /100 I don’t seem to be able to concatenate these two formulae =IF(E4>B10,E5)*2/100 =IF(E4<=B10,E5)/100Solved1.2KViews0likes2CommentsHelp with Excel Formula and table lookup
I need help with a formulae in the "Answer" cell that checks the Width Value and the Length Value against the table of values to the right. It should then bring back the correct value. I have added examples below. I hope someone can assist. Examples If Width was 60 and Length was 158, the answer would be 120 If Width was 48 and Length was 150, the answer would be 105 If Width was 48 and Length was 60, the answer would be 75 because it is up to and including 60 for the width, up to and including 90 for the length If Width was 91 and Length was 245, the answer would be 205 Many thanks in advance. Width 68 WIDTH 60 90 120 150 180 210 240 Length 158 Length 90 75 100 130 160 190 220 260 Answer 145 120 90 115 145 175 205 235 275 150 105 130 160 190 220 250 290 180 120 145 175 205 235 265 305 210 135 160 190 220 250 280 320 240 150 175 205 235 265 295 335Solved2.3KViews0likes6Comments
Recent Blog Articles
No content to show