Get wrong value in Nested If formula

[acheek]

Ok cant seem to figure this out please help

IF cell B1 is greater than 0 then check to see if B1 is less than A1. , if B1 is less than A1 enter B1, If B1 is greater than A1 enter A1. If B1 is less than 0 then enter A1

I think it should look like this but it isnt working


=IF(B1>0,IF(B1<A1,B1,A1),A1)

Thanks

[acheek]

Sorry figured it out. The data in my B column was formated as text not a number.

[etaf]

the formula looks correct
what errors are you getting

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve - and show what errors you are getting .

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Jonmo1]

Works for me, in what way does it not work for you?

Can you show a few example values of A and B, what result you get, what result you wanted?

[acheek]

I got it the values in B column were not formated as numbers. The formula is correct. Thanks for quick replies and your help