Previous Topic Next Topic

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
i found this formula from some website, its sort of what im looking for but not exactly...

Example:

IF(A1 <= 0; "ordering", "stock")
This would mean: If the contents of cell A1 is less than or equal to zero, then it displays "to order", otherwise (if the contents of cell A1 is greater than zero) on display "at stock".


I am looking for a formula for cell B1 that if cell A1 is <= 0, it will pull value from cell A2, but if cell A1 is >0 it will pull value from cell A3. in the example above i tried to substitute "to order" and "at stock" with cell locations, but that didnt work.

I guess in my mind it seems like a simple process but I am excel illiterate, please help.
Related:

2 responses

Answer 1 / 2
Blocked Profile
Sep 30, 2009 at 03:46 AM
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.
neverlost41
Sep 30, 2009 at 10:07 AM
can you give me an example of what the foruma might look like? I am trying to do this but its coming up as an error.
Trowa > neverlost41
Oct 1, 2009 at 08:31 AM
quote
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
Answer 2 / 2
cliffmid Posts 3 Registration date Wednesday September 30, 2009 Status Member Last seen October 1, 2009
Oct 1, 2009 at 09:12 AM
try this

=IF(A1<=0, A2, A3)

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses