Thread: Negative numbers in an IF formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bearacade Bearacade is offline
external usenet poster
  
Posts: 1
Default Negative numbers in an IF formula

You are getting a #value because of the E10 comment. Change it to
IF(E10=0,0,E10))

Another thing is you might want to use large instead of the the IF
command, I think it's cleaner:

Personally, you don't even need the whole E10 thing..

=IF(D9="","",IF(AND(G90,G100),"",LARGE(G9:G10,1) +E10))

It's cleaner this way.. you will STILL get a #Value if anything other
than number is in E10..

You can protect against that with:

=IF(D9="","",IF(AND(G90,G100),"",LARGE(G9:G10,1) +IF(ISNUMBER(E10),E10,0)))


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=563067

Reply With QuoteReply With Quote