Excel formula

Closed
Elizabeth - Sep 16, 2010 at 11:09 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 20, 2010 at 08:58 PM
Hello,
can someone please help I need to get rid of the FALSE value in the formated cells. I know I am doing something wrong. Here is my formula:

=IF(K24:K121="A",250*J23:J121,(IF(K24:K121="S",95*J23:J121)))

Thanks!


Related:

2 responses

I think this is what you need

=IF(K24:K121="A",250*J23:J121,AND(K24:K121="S",95*J23:J121))

need the and not two ifs
see if that works
Thanks Bear...

I copied and pasted your formula..still no luck. A false appears when there is nothing in the K cells.

I do appreciate your time. I have been pulling my hair out!

If you have any more ideas please let me know.

Thanks,
Elizabeth
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 19, 2010 at 06:05 AM
What are you trying to do ? Beside that one thing that I notice is that for 2nd if, there is nothing to do or show if condition is false, in that case default "false" would show. Other thing is that your if ranges and formula ranges do not match, one is 24:121 and other is 23:121. Perhaps you should look into use of SUMPRODUCT.
0
I am setting up a spread sheet to calculate charges; One column is for spent on case; another is for who is doing the work (A) for attorney (s) for staff..so I would like for the formula to calculate a different rate per hour for each; However, if nothing is entered in a cell where the formula is present I would like to have an empty space instead of false.

When I posted the formula I meant for the ranges to match.

I know just enough to be dangerous when it comes to excel..I am trying to learn more. I there is a better function to use please let me know.

Thanks for the help
Elizabeth
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 20, 2010 at 08:58 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link
0