Need formula help with excel
Closed
neverlost41

Sep 30, 2009 at 12:23 AM
cliffmid Posts 3 Registration date Wednesday September 30, 2009 Status Member Last seen October 1, 2009  Oct 1, 2009 at 09:12 AM
cliffmid Posts 3 Registration date Wednesday September 30, 2009 Status Member Last seen October 1, 2009  Oct 1, 2009 at 09:12 AM
Related:
 Need formula help with excel
 Excel grade formula  Guide
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Excel free download  Download  Spreadsheets
2 responses
Dear Sir,
Please try using two different formulas for solving the problem and then combine them if they work well. One should pull the value for less than zero and the other one for greater value of zero.
Thanks.
Please try using two different formulas for solving the problem and then combine them if they work well. One should pull the value for less than zero and the other one for greater value of zero.
Thanks.
cliffmid
Posts
3
Registration date
Wednesday September 30, 2009
Status
Member
Last seen
October 1, 2009
Oct 1, 2009 at 09:12 AM
Oct 1, 2009 at 09:12 AM
try this
=IF(A1<=0, A2, A3)
=IF(A1<=0, A2, A3)
Sep 30, 2009 at 10:07 AM
Oct 1, 2009 at 08:31 AM
IF(A1 <= 0; "ordering", "stock")
unquote
Note that you are using two kinds of separators ";" and ",". I'm using a dutch version and need to use ";", but most people on this forum need to use ",". I'm assuming you need to use the ",".
To aswer your question look at the syntaxis of the IF function:
IF(condition which can be true or false, value or cell when condition is true, value or cell when condition is false)
In your case it would look like this: IF(A1<= 0,A2,A3) .
Best regards,
Trowa