Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Is F10 in "MDA Template" empty?
Excel will treat that as a 0. Second guess... You have calculation set to manual. Tools|options|calculation tab to check/change. Micayla Bergen wrote: 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 -- Dave Peterson |
#3
|
|||
|
|||
F10 is not empty - it is the only cell in the MDA template worksheet that is
not. Calculation is already set to automatic "Dave Peterson" wrote: Is F10 in "MDA Template" empty? Excel will treat that as a 0. Second guess... You have calculation set to manual. Tools|options|calculation tab to check/change. Micayla Bergen wrote: 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 -- Dave Peterson |
#4
|
|||
|
|||
Dave i had 2 worksheets the same and was using the 'copy' instead of the real
one sorry to waste your time thanks for attempting to help this excelling idiot "Dave Peterson" wrote: Is F10 in "MDA Template" empty? Excel will treat that as a 0. Second guess... You have calculation set to manual. Tools|options|calculation tab to check/change. Micayla Bergen wrote: 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 -- Dave Peterson |
#5
|
|||
|
|||
Glad you found your solution and thanks for posting back.
Don't you hate these kinds of errors?? Micayla Bergen wrote: Dave i had 2 worksheets the same and was using the 'copy' instead of the real one sorry to waste your time thanks for attempting to help this excelling idiot "Dave Peterson" wrote: Is F10 in "MDA Template" empty? Excel will treat that as a 0. Second guess... You have calculation set to manual. Tools|options|calculation tab to check/change. Micayla Bergen wrote: 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 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |