asked on # Need a simple formula in excel to fill column based on other columns

In my sheet I have column B which is a number 0-4

Columns C through F are blank or 1

Columns G through J I want to set via the following logic

if C# is 1 and B#=1 then set value to 1

if C# is 1 and B#=2 then set value to .50

if C# is 1 and B#=3 then set value to .33

if C# is 1 and B#=4 then set value to .25

Columns C through F are blank or 1

Columns G through J I want to set via the following logic

if C# is 1 and B#=1 then set value to 1

if C# is 1 and B#=2 then set value to .50

if C# is 1 and B#=3 then set value to .33

if C# is 1 and B#=4 then set value to .25

Microsoft ExcelMicrosoft Office

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.