SOLVED

I think I need a If Then formula

Copper Contributor

=if(D3>1.5; ''ok''; ''not ok'' ) this formulae refused to work in excel. How can I fix it?

2 Replies
best response confirmed by ronuka19-1_2 (Copper Contributor)
Solution
Change the semicolon for a comma, should work then.
=if(D3=1.5,"ok","not ok" if it doesn't work then maybe D3 is format as text rather than a number.

worked like magic....thanks mate@Rich99 

1 best response

Accepted Solutions
best response confirmed by ronuka19-1_2 (Copper Contributor)
Solution
Change the semicolon for a comma, should work then.
=if(D3=1.5,"ok","not ok" if it doesn't work then maybe D3 is format as text rather than a number.

View solution in original post