Formula to “subtract” one cell from another cell if text criteria in a third cell is met

Hi my name is Ross, I'm an independent advisor. I'd be happy to help with your issue.

To explain this I’ll use this example,

Value 1 is in A1, value 2 is in B1, the criteria value is in C1 and the cell with the formula would be in D1.

I want C1 to equal Apples as the criteria. If it does not match then just display blank

.

=IF(C1="Apples",A1-B1,"")

Regards,

Ross

Hi,

Ok I think I understand a little better now, for your use case here I would suggest this formula to go in K3 and you can then fill across.

=VLOOKUP(K$1,$A:$C,3,FALSE)-VLOOKUP(K$1,$A:$H,8,FALSE)

Regards,

Ross

Ok, could you explain it a little further and I will try and assist.

If it is simply you want to add text to the result, just place this between the quotation marks.

Regards,

Ross

Sorry, but the text cell in my report will not be blank. It will have one of eight different text entries to reflect the type of item being received/issued.

Dear Elmer 

Will be a great help to find the right solution to your problem if you could explain to us with more details your scenario, obviously, we don't know how it looks like.

Regards

Sorry, but the text cell in my report will not be blank. It will have one of eight different text entries to reflect the type of item being received/issued.