Excel Formular
Please how do i enter this formular in excel
if 0.2 < x 0.8. |
Excel Formular
If you meant:
if 0.2 < x < 0.8. One way: =if(and(0.2<a1,a1<0.8),"between .2 and .8","not between") A1 is the cell that contains x. Stats student wrote: Please how do i enter this formular in excel if 0.2 < x 0.8. -- Dave Peterson |
Excel Formular
Thanks Dave. This was what i needed. I am really grateful
"Dave Peterson" wrote: If you meant: if 0.2 < x < 0.8. One way: =if(and(0.2<a1,a1<0.8),"between .2 and .8","not between") A1 is the cell that contains x. Stats student wrote: Please how do i enter this formular in excel if 0.2 < x 0.8. -- Dave Peterson |
All times are GMT +1. The time now is 07:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com