Micayla Bergen

Posts: n/a

another IF function

i have this formula =IF('MDA Template'!F10=0,"n/a",I10*0.25), i want to have
my cell equal the result of I10x0.25 if F10 on the other sheet does not equal
zero. in this instance everything equals zero except F10 but it still says
'n/a'. what have i done wrong?
Thanks

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
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM
Need a ISWorkday Function -- Any Ideas	Mark	Excel Worksheet Functions	5	March 29th 05 01:58 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc	Elijah-Dadda	Excel Worksheet Functions	0	March 5th 05 03:31 AM
Conversion	SVC	Excel Worksheet Functions	9	February 28th 05 02:29 PM
Formula to list unique values	JaneC	Excel Worksheet Functions	4	December 10th 04 12:25 AM

All times are GMT +1. The time now is 02:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us