Forum Discussion

Copper Contributor

Jan 28, 2023

Solved

4 IF formulas for 1 result

I have 4 cells per row, only one will have a value of 1, the others will remain empty. Each cell needs to return a different value in the formula cell (eg. cell D2 would return 3, E2 would return...

Formulas and Functions

OliverScheurich
Jan 28, 2023
G12Fee
=IF(OR(D2=1,G2=1),3,IF(E2=1,7.5,IF(F2=1,6,0)))

You can try this formula.

OliverScheurich

Gold Contributor

Jan 28, 2023

G12Fee

=IF(OR(D2=1,G2=1),3,IF(E2=1,7.5,IF(F2=1,6,0)))

You can try this formula.

G12Fee

Copper Contributor

Jan 28, 2023

OliverScheurich This is perfect, thank you.