If Function

  • Thread starter Thread starter Tom Donino
  • Start date Start date
T

Tom Donino

I am having trouble using the if function. I am trying to
have a cell(J4) return either the value of defined name
(newteamcost) or (old teamcost) depending on whether the
value in (b4) is O or N (Capital O or Capital N). Any
help would be appreciated.
 
Tom

From your wording, I take it, that lower case
o or n are not allowed. If this holds, here's one
way to do it:

In J4:

=IF(EXACT(B4,"O"),newteamcost,IF(EXACT(B4,"N"),oldteamcost,""))
 
Thanks for the reply but that is not working. I also
tried removing the (EXACT portion of eac and the end
parentheses but that is not working either.
 
What is not working?
Please specify.
What happens, when you enter the formula?

LeoH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Function 4
Multiple Fxns in single sheet module 0
Output from Frames - multiple optionbutton groups 1
Making Excel understand the diffrence in capitialization? 8
difficult function 2
Excel Need assistance with modifying a Duplicate declaration. 13
using defined name in UDF 7
Supressing a #VALUE! error returned? 3

Back
Top