Conversation I think I need a If Then formula in Excel
https://techcommunity.microsoft.com/t5/excel/i-think-i-need-a-if-then-formula/m-p/557375#M30780
<P>=if(D3>1.5; ''ok''; ''not ok'' ) this formulae refused to work in excel. How can I fix it?</P>Fri, 10 May 2019 08:54:57 GMTronuka19-1_22019-05-10T08:54:57ZI think I need a If Then formula
https://techcommunity.microsoft.com/t5/excel/i-think-i-need-a-if-then-formula/m-p/557375#M30780
<P>=if(D3>1.5; ''ok''; ''not ok'' ) this formulae refused to work in excel. How can I fix it?</P>Fri, 10 May 2019 08:54:57 GMThttps://techcommunity.microsoft.com/t5/excel/i-think-i-need-a-if-then-formula/m-p/557375#M30780ronuka19-1_22019-05-10T08:54:57ZRe: I think I need a If Then formula
https://techcommunity.microsoft.com/t5/excel/i-think-i-need-a-if-then-formula/m-p/557547#M30783
Change the semicolon for a comma, should work then.<BR />=if(D3=1.5,"ok","not ok" if it doesn't work then maybe D3 is format as text rather than a number.Fri, 10 May 2019 09:45:20 GMThttps://techcommunity.microsoft.com/t5/excel/i-think-i-need-a-if-then-formula/m-p/557547#M30783Rich992019-05-10T09:45:20ZRe: I think I need a If Then formula
https://techcommunity.microsoft.com/t5/excel/i-think-i-need-a-if-then-formula/m-p/560316#M30811
<P>worked like magic....thanks mate<LI-USER uid="259521"></LI-USER> </P>Sat, 11 May 2019 04:22:09 GMThttps://techcommunity.microsoft.com/t5/excel/i-think-i-need-a-if-then-formula/m-p/560316#M30811ronuka19-1_22019-05-11T04:22:09Z