CAN I HAVE TWO IF FUNCTIONS

B

barry

I am using this formula
=IF(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)=YES,F12/11,IF(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)=MIXED,"ENTER",0))
in coulmn "g" and would like to know if it is possible to have another
condition added to this formula to check the next column and if true then
insert 0 . the next column would be "d"
I have tried AND plus & and several other ways but cannot seem to get the
fomrula to work.
Thank you for your assistance.
 
M

mubashir aziz

Try to use Iserror function .....

=IF(ISERROR(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)),IF(ISERROR(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)),0,"ENTER"),
F12/11)))
 

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

Cumulative formula for word table 0
Vlook-up in report with column Expansion 5
Same forumula returns both 0 & N/A 2
Dragging a formula down isn't working - where am I going wrong? 1
combine three if functions 3
IF Statement on multiple levels 6
IF AND VLOOKUP formula needed 1
SUMPRODUCT and Dates 2

Top