hi
you are a bit sketchy on details so i made some up.
A5=50
B5=EXCL
in C5 enter this formula
=if(B5="EXCL",A5*-1,0)

if that is not how your data is layed out, post back with more details.

Regards
FSt1

"LaDonna Brooks" wrote:

Is there a formula that I could use if it says EXCL (meaning exclude) to have
it enter that amount in another cell as a minus?


msladona