Complex IF AND OR function formula

OK so I have a lot to explain but here is what I need

Please see attached file!

So I need Excel to
1) calculate the difference between "Price Ordered" and "Price received" ... I would like the number to NOT be a negative or change color I just want the plain number (whether it's more or less)
2) automatically fill in "D4" with "Over" or "Short" ... if it is equal, just leave it blank
I have gotten this far on my own but I think the main problem is that I am not doing the formula in the correct order
3) the "Price Ordered" will ALWAYS be on the sheet, we will enter the Price Received weekly since it changes .... the way I did it, the difference will ALWAYS shows "$10" and "Short" in C4 and D4...my question is, how can I leave C4 and D4 Blank until I fill in B4? and when I do fill in B4 how can I make it say "Over", "Short" or leave it blank if it is equal to A4?

I have attached a file and that's what I would like for it to look like but I just need the formulas to do so

I really hope this makes sense to somebody! I have been cracking my head over this for DAYS!

Thanks!

This is awesome!!! Thank you so much!!

One more thing... what would I have to add if the difference is ZERO? I don't want a Zero there, I would just like for it to be blank ... help?

Originally Posted by Crooza

Welcome to the site.
try this
C4 = IF(B4="","",B4-A4
D4 = =IF(B4="","",IF(B4>A4,"over","short"))

You can add another nested if to D4 if you really want to capture the case when A4 and B4 are equal