If Formula

P

PHIL.Pearce84

Board Regular
Joined
May 16, 2011
Messages
152
Office Version
  1. 365
Platform
  1. Windows
Can anyone help with this multiple criteria IF formula I know its wrong but I cant work out what to do?

Thanks


=IF(D14=E14,F14< J14,"Full HB","Monitor Account")
 
Last edited by a moderator:

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
If this is not what you want, please explain what you are trying to achieve

=IF(AND(D14=E14,F14< J14),"Full HB","Monitor Account")
 
Upvote 0
If your formula contains < signs you need to surround them with spaces in order for the board to display correctly.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Cell with 0 value showing blank
2
Replies
15
Views
752
mhessnm
M
R
  • Question Question
Repeated rows with formula based on filtered selection
Replies
6
Views
275
My Aswer Is This
My Aswer Is This
Burrgogi
  • Question Question
Pivot table data reporting problem
Replies
1
Views
265
Misca
M
J
  • Solved
Multi-criteria lookup
Replies
3
Views
293
Asbestos_Jen
Asbestos_Jen
H
  • Question Question
Launch userform on specific monitor
Replies
2
Views
164
HOGAN2023
H

Forum statistics

Threads
1,224,534
Messages
6,179,390
Members
452,909
Latest member
VickiS

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