IF Statement Help

D

DavidWe

New Member
Joined
May 15, 2006
Messages
24
I would like to do the following:

If D7 = "Credit"
Then M7 = L7 * -1

I get a "Value" error with
IF(D7 = "Credit",L7 * -1)

I also tried
IF(D7 = "Credit","=L7 * -1")

What is the correct syntax?

Thanks
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
I forgot to say that I'm using 2007. I think the solution to my question will apply to all versions.
 
Upvote 0
Oops. I did not have a space between D7 and =. It worked as soon as I added it. I'm going to take a break.

Thanks for your help.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Transpose dates in rows to columns
2
Replies
10
Views
150
Skyybot
Skyybot
I
  • Question Question
Automatically changing the colour on a cell based on the date (code in macro)
Replies
2
Views
317
ishkarayil
I
K
  • Question Question
Create new Workbook from exist
Replies
5
Views
146
KreshBell
K
E
  • Solved
Running Multiplication LAMBDA Function?
Replies
4
Views
200
RoryA
RoryA
J
  • Question Question
Toying with idea of making a fullfledged tax return computation for 1040 form in excel
Replies
4
Views
179
Joe4
Joe4

Forum statistics

Threads
1,224,505
Messages
6,179,151
Members
452,891
Latest member
JUSTOUTOFMYREACH

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top