Results 1 to 3 of 3

Thread: If Error Statement

  1. #1

    If Error Statement



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please see the attached for help with a formula.
    Thank you!!!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Excel Formula.JPG 
Views:	18 
Size:	28.3 KB 
ID:	4680  

  2. #2
    Acolyte Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    99
    Articles
    0
    Excel Version
    2013, 2016, O365
    Using your posted scenaro...
    A
    B
    1
    900.00
    2
    77.09%
    900.00
    3
    50.00%
    900.00

    Try this formula, copied down:
    C1: =B1*IF(AND(A1<=77.09%,A1<>""),0.5,1)

    These are the results:
    A
    B
    C
    1
    900.00
    900
    2
    77.09%
    900.00
    450
    3
    50.00%
    900.00
    450

    Is that something you can work with?
    Ron Coderre
    Former Microsoft MVP (2006-2015)

  3. #3
    Thank you Ron!!! It worked Very much appreciate your quick response.

Tags for this Thread

Posting Permissions

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