Change the formula as follows :
=IF(B2="P1";LOOKUP(B3*24;G6:K6;G4:K4);LOOKUP(B3*24;G6:K6;G5:K5))
This will convert to decimal values
Change the formula as follows :
=IF(B2="P1";LOOKUP(B3*24;G6:K6;G4:K4);LOOKUP(B3*24;G6:K6;G5:K5))
This will convert to decimal values
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks