If(Hlookup) statement

Closed

Sandy - Jan 23, 2009 at 05:12 PM
jurstiss Posts 18 Registration date Monday December 29, 2008 Status Member Last seen June 14, 2009 - Jan 24, 2009 at 02:05 AM

Hello,
I am trying to create a If statement that will 0 negitive values and if a specific cell contains a 1 my formula will change. I have been sucessful in one or the other but can't seem to combine the two. This is what I have so far. '=(IF(OR(IF(HLOOKUP($B$1,'Data input'!$A$1:$GZ$35,F9,FALSE)=1,(B11-B9)*1440,(B11-B10)*1440),(B11-B9)*1440,(B11-B10)*1440)<0,0,IF(HLOOKUP($B$1,'Data input'!$A$1:$GZ$35,F9,FALSE)=1,(B11-B9)*1440,(B11-B10)*1440)))

If(Hlookup) statement
Fenix internet on bank statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Excel if statement - Guide
Sbi bank statement - Guide
Excel if statement contains multiple words ✓ - Excel Forum

1 response

Answer 1 / 1

jurstiss Posts 18 Registration date Monday December 29, 2008 Status Member Last seen June 14, 2009 3
Jan 24, 2009 at 02:05 AM

hi,
try this link to get a number of formulas which can help you doing your work:

https://www.mrexcel.com/archive/Formulas/

Similar discussions

Removing " false" value in "IF"

removing false in excel

Removing False Value

Need help to remove FALSE from cell

Removing "FALSE" from an IF statement with a VLOOKUP

Similar discussions

Subscribe To Our Newsletter!