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") |
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") |
All times are GMT +1. The time now is 11:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com