| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement for cell ranges to equivalent value
Hi Jacob,
This is it, Thanks a lot for helping me and the rest. More power! Rechie "Jacob Skaria" wrote: Do you mean =IF(SUM(A2:A10),20,"") If this post helps click Yes --------------- Jacob Skaria "Rechie" wrote: Hi, Formula to get a equivalent of fixed value. Formula to type in A1: If range A2:A10=non blank (numeric value), then A1=20. Appreciate your time and help. Rechie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement using number ranges | New Users to Excel | |||
| What is the Excel equivalent of the CELL function? | Excel Worksheet Functions | |||
| empty cell equivalent value | Excel Worksheet Functions | |||
| If Statement Between Ranges? | Excel Discussion (Misc queries) | |||
| CASE statement equivalent | Excel Worksheet Functions | |||
Threaded Mode
