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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 20, 2010 at 08:58 PM
Related:
- Excel formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
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
=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
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
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.
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 20, 2010 at 08:58 PM
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
