Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help - i don't know how to title this!
Hi.
I've got a basic percentage formula that i would like to enhance. Currently the formula reads: =sum(I15-H15)/H15 But, i would like it to look into column L (within a specific cell range) and generate a different formula if it finds a figure in this column. The new formula would read: =sum(I15-L15)/L15 Any ideas whether to use VLOOKUP or IF?? In addition, I would like the formula to generate a 'n/a' if an '£0.00' was found in in the initial cells used. (This only applies to the first part of the formula). So in the example below, =sum(I15-H15)/H15 the formula would generate n/a if there was £0.00 in either cel I15 or H15. Much appreciated. Carol |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help - i don't know how to title this!
Try this:
=IF(OR(I15=0,H15=0,L15=0),"n/a",IF(L15<"",(I15-L15)/L15,(I15-H15)/ H15)) No need for the SUM part. Hope this helps. Pete On Apr 25, 12:59*pm, carol wrote: Hi. I've got a basic percentage formula that i would like to enhance. Currently the formula reads: =sum(I15-H15)/H15 But, i would like it to look into column L (within a specific cell range) and generate a different formula if it finds a figure in this column. The new formula would read: =sum(I15-L15)/L15 Any ideas whether to use VLOOKUP or IF?? In addition, I would like the formula to generate a 'n/a' if *an '£0.00' was found in in the initial cells used. (This only applies to the first part of the formula). So in the example below, =sum(I15-H15)/H15 the formula would generate n/a if there was £0.00 in either cel I15 or H15. Much appreciated. Carol |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help - i don't know how to title this!
Thanks so much Pete.
It worked a treat! "Pete_UK" wrote: Try this: =IF(OR(I15=0,H15=0,L15=0),"n/a",IF(L15<"",(I15-L15)/L15,(I15-H15)/ H15)) No need for the SUM part. Hope this helps. Pete On Apr 25, 12:59 pm, carol wrote: Hi. I've got a basic percentage formula that i would like to enhance. Currently the formula reads: =sum(I15-H15)/H15 But, i would like it to look into column L (within a specific cell range) and generate a different formula if it finds a figure in this column. The new formula would read: =sum(I15-L15)/L15 Any ideas whether to use VLOOKUP or IF?? In addition, I would like the formula to generate a 'n/a' if an '£0.00' was found in in the initial cells used. (This only applies to the first part of the formula). So in the example below, =sum(I15-H15)/H15 the formula would generate n/a if there was £0.00 in either cel I15 or H15. Much appreciated. Carol |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
help - i don't know how to title this!
You're welcome, Carol - thanks for feeding back.
Pete On Apr 25, 1:49*pm, carol wrote: Thanks so much Pete. It worked a treat! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where's my title bar? | Excel Discussion (Misc queries) | |||
Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
Title in row 1 | Excel Discussion (Misc queries) | |||
Show full path title in title bar? | New Users to Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |