Posted to microsoft.public.excel.worksheet.functions

Diana

external usenet poster

Posts: 61

Adding results from a If formula-Short in time

how do I add the results of if formulas =if(I3="YES","5", IF(I3="NO", "0")).
or how can I convert the results of this if formula to a number and later add
it at the end of the row.

thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Having a problem formatting short time	clueless	New Users to Excel	1	July 21st 08 01:46 AM
Formula for adding time eg. 13:45 + 22:15 + 10:45 + 19:30	Denie	New Users to Excel	1	July 27th 07 09:28 AM
SUM problem: adding formula results	JPN5804	Excel Discussion (Misc queries)	2	November 28th 05 04:29 AM
Date & time short cut	Conditional Formatting	Excel Worksheet Functions	1	November 21st 05 05:05 PM
What is the formula to display a negative time results?	Robluc65	Excel Worksheet Functions	1	October 14th 05 11:15 PM

All times are GMT +1. The time now is 04:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us