Results 1 to 3 of 3

[SOLVED] Modulus Function

Threaded View

darksupernova [SOLVED] Modulus Function 12-07-2009, 02:03 PM
StephenR Re: Modulus Function 12-07-2009, 02:14 PM
darksupernova [SOLVED] Re: Modulus Function 12-07-2009, 02:34 PM
  1. #1
    Registered User
    Join Date
    08-08-2008
    Location
    UK
    Posts
    24

    [SOLVED] Modulus Function

    Hey there,

    I had a quick search but couldnt find what i was looking for, basically im looking to use the mathematical modulus of a function in excel, however whenever i search i keep finding the MOD() function which isnt what im looking for (i dont think)...

    I have a formula and in it is a square root, i want the formula inside the square root always to be positive so i get a result.

    Example:

    (A1)
    -1
    (A2)
    0
    (A3)
    -2

    (C1)
    =(A1)^0.25
    (C2)
    =(A2)^0.25
    (C3)
    =(A3)^0.25

    Now i only get a result from the last two, but i want to use the modulus function so that instead of a maths error i get 1 for the first one, how do i do this?

    Thanks,

    Max
    Last edited by darksupernova; 12-07-2009 at 02:34 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1