Hello, If A1 = 80 then B1 = 100 or if A1 = 50 then B1 = 90 both these formules are in the same cell, Thanks Configuration: Windows XP / Internet Explorer 8.0

IF

Solved/Closed

Stormdronk - May 25, 2010 at 02:49 AM
Stormdronk - May 25, 2010 at 06:22 AM

Hello,

If A1 = 80 then B1 = 100 or if A1 = 50 then B1 = 90 both these formules are in the same cell, Thanks

Answer 1 / 2

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
May 25, 2010 at 05:30 AM

inn B1 copy this formula

=IF(A1=80,100,IF(A1=50,90,""))

Answer 2 / 2

Stormdronk
May 25, 2010 at 06:22 AM

Thanks !!!!!!!