Previous Topic Next Topic

Need formula help with excel

Closed
neverlost41 - 30 Sep 2009 à 00:23
cliffmid Posts 3 Registration date Wednesday 30 September 2009 Status Member Last seen 1 October 2009 - 1 Oct 2009 à 09:12
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

Réponse 1 / 2
Blocked Profile
30 Sep 2009 à 03:46
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
30 Sep 2009 à 10:07
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
1 Oct 2009 à 08:31
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
Réponse 2 / 2
cliffmid Posts 3 Registration date Wednesday 30 September 2009 Status Member Last seen 1 October 2009
1 Oct 2009 à 09:12
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