abete79Copper ContributorOct 02, 2024IF function ? Dear All, I have the following task to solve. I have variable data in one cell which used for further calculation. There are basically only two variants 30 or 60. If the value is 30 the callculat...Show More
LorenzoSilver ContributorOct 02, 2024Hi abete79 One option:in E3: =(B3 + C3) * 60 * IF(D3 = 30, 2, 1)or=(B3 + C3) * IF(D3 = 30, 120, 60)
