Hi,
I was wondering if there is a formula I can create that can multiply two numbers based on a word on another column...here's what I mean...
On column R there are some rows that have the word Canada on it.
there are numbers on column H.
So I want to type a formula on column that says, if you see the word Canada on column R then multiply the number on column H times .75
The formula I typed doesn't seem to be working which is =IF(R3="Canada",H3*0.75","")
Is this correct? Please advise. Thanks.
Cele
Bookmarks