Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How can i use a conditional formula to return one of 4 values,
if C:13 is less than 274 should be 8, if C:13 is less than 329 should be 16, if C:13 is more than 329 should be 24, if C:13 is more than 438 should be 32. I know I'm close tough not quite =(C13<274)*8 + (C13274=16)*(C13<329=24)*24 + (C13438)*32 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Formula for Returning values in another spreadsheet | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions |