| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if this equals that
I am trying to come up with a spreadsheet where if you either type in a X in
A2 ... in column C you will get 10. Then say if you leave A3 blank.. in column C it will be 0. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if this equals that
Hi, try if(a2<"",10,0)
hope this helps Regards from Brazil Marcelo "MAML" escreveu: I am trying to come up with a spreadsheet where if you either type in a X in A2 ... in column C you will get 10. Then say if you leave A3 blank.. in column C it will be 0. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if this equals that
=if(A2="X",10,0)
"MAML" wrote: I am trying to come up with a spreadsheet where if you either type in a X in A2 ... in column C you will get 10. Then say if you leave A3 blank.. in column C it will be 0. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| how to run a macro when a calculation equals a certin number | Excel Worksheet Functions | |||
| Apostrophes instead of equals in Excel | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
| Can I change the Insert Function button to an equals sign? | Excel Discussion (Misc queries) | |||
Linear Mode
