If function - Microsoft Community

formula	cost1	cost2	cost3
ok	$5		$2	2
	$10	$20	$6	$4

1	a	b	c	d
2	formula	cost1	cos2	cost3
3		5
4		10
5

formula: =if(b3<3, 200, "")

erro message : 

  

there's problem formula

not trying type formula?

when........"

formula	cost1	cost2	cost3
ok	$5		$2	2
	$10	$20	$6	$4

1	a	b	c	d
2	formula	cost1	cos2	cost3
3		5
4		10
5

formula: =if(b3<3, 200, "")

erro message : 

there's problem formula

not trying type formula?

when........"

your formula works me.

check language  regional settings in control panel verify list separator has not been set semi-colon rather comma.

===

regards,

norman

Office / Excel / Windows other / Office 365 Home