If statements with cell dependancies

Two questions:

1) How do I make a cell (C1 for example) who's formula is "=A1-B1" show the difference of those two cells unless the answer is 0 in which case I want it to report "N/A"? In other words, if A1 is "10" and B1 "5", then C1 would report "5" but if A1 was "10" and B1 was "10" then C1 would report "N/A" and not "0."

2) This one is more involved as it relys on the value of another cell but here goes: I need a formula that will pull a number from a cell two rows above it but depending on the text in the cell two rows below it I may need it to adjust that number accordingly. For clarification: Assume that cell B5 will always contain 1 of the following 3 text entries: DISTINCT, CAPTURED, or ASSUMED. Cell B1 will always contain a number to one decimal place (i.e. 7.2 or 55.6). I need a formula in cell B3 that pulls the number from B1 but alters it depending on the text in B5. If B5's text is "DISTINCT" I want B3 to show B1's value exactly without any alteration. But if B5's text is "CAPTURED or ASSUMED" I want B3 to show B1's value exactly UNLESS B1 is less than 44 in which case I want B3 to display the "44.0." So if B1 is "98.0" and B5 is either "CAPTURED" or "ASSUMED" than B3 should report "98.0" but if B5 is "17.9" with B5 still being either "CAPTURED" or "ASSUMED" then B3 would report "40.0."

Any help would be greatly appreciated

Deleted (is there an option to actually delete these posts?)

Thanks alot for the anwers abousetta!! Holy maceral!! You're a genius!!

I apologise for being remiss in not stopping this thread sooner.

Please take a few minutes to read the forum rules, and amending the thread title accordingly.

Thanks.

Thanks shg

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Deleted...

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You can change the title at the same time