If(Hlookup) statement

Closed
Sandy - 23 Jan 2009 à 17:12
jurstiss Posts 18 Registration date Monday 29 December 2008 Status Member Last seen 14 June 2009 - 24 Jan 2009 à 02:05
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)))

1 response

jurstiss Posts 18 Registration date Monday 29 December 2008 Status Member Last seen 14 June 2009 3
24 Jan 2009 à 02:05
hi,
try this link to get a number of formulas which can help you doing your work:

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