Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert formula result into numbers so I can sum results?
I'm orderd by my boss to make a report form. So I need to make some
calculations... How can I convert formula result into numbers? This is an example from my formula: 1 2 3 4 A S S S S B =IF(A1="S", "1") c =IF(A2="S", "1") D =IF(A3="S", "1") E =SUM(B1:D1) (No action - no result, but I need E1 to be "3") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert formula result into numbers so I can sum results?
=IF(A1="S", 1,0)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Barsha" wrote in message ... I'm orderd by my boss to make a report form. So I need to make some calculations... How can I convert formula result into numbers? This is an example from my formula: 1 2 3 4 A S S S S B =IF(A1="S", "1") c =IF(A2="S", "1") D =IF(A3="S", "1") E =SUM(B1:D1) (No action - no result, but I need E1 to be "3") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN I CONVERT A NUM IN WORDS (EXCEL) | Excel Discussion (Misc queries) | |||
Rs.10,250.00 formula Rupees ten thousand two hundred fifty only | New Users to Excel | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
Currency to Text | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions |