| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cell
Hello,
I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
"Kevins" wrote in message
... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
Stephen, thanks for the help.
Here's the original formula. =IF(G13F13,"OVERPAID","PAID") I'm looking for the formula to only return a value in cell I13 if there is a value in G13. "Stephen" wrote: "Kevins" wrote in message ... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
So,
=IF(G13="","",IF(G13F13,"OVERPAID","PAID")) "Kevins" wrote in message ... Stephen, thanks for the help. Here's the original formula. =IF(G13F13,"OVERPAID","PAID") I'm looking for the formula to only return a value in cell I13 if there is a value in G13. "Stephen" wrote: "Kevins" wrote in message ... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
How 'bout
=IF(ISNUMBER(G13),IF(G13=F13,"PAID",IF(G13<F13,"UN DERPAID","OVERPAID")),"") "Kevins" wrote: Stephen, thanks for the help. Here's the original formula. =IF(G13F13,"OVERPAID","PAID") I'm looking for the formula to only return a value in cell I13 if there is a value in G13. "Stephen" wrote: "Kevins" wrote in message ... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
Brilliant Stephen - does the job perfectly!
Now I can get back to something more productive. Good luck and many thanks. "Stephen" wrote: So, =IF(G13="","",IF(G13F13,"OVERPAID","PAID")) "Kevins" wrote in message ... Stephen, thanks for the help. Here's the original formula. =IF(G13F13,"OVERPAID","PAID") I'm looking for the formula to only return a value in cell I13 if there is a value in G13. "Stephen" wrote: "Kevins" wrote in message ... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
Ed,
I think I see what this formula is designed to do unfortunately, having typed it in as it is written here, it doesn't actually return a value at all in cell I13, regardless of the values entered in cells F13 and G13. "Ed Cones" wrote: How 'bout =IF(ISNUMBER(G13),IF(G13=F13,"PAID",IF(G13<F13,"UN DERPAID","OVERPAID")),"") "Kevins" wrote: Stephen, thanks for the help. Here's the original formula. =IF(G13F13,"OVERPAID","PAID") I'm looking for the formula to only return a value in cell I13 if there is a value in G13. "Stephen" wrote: "Kevins" wrote in message ... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
Ed,
My error - it works very well if I actually point it at the correct cells! Thanks for the help. "Kevins" wrote: Ed, I think I see what this formula is designed to do unfortunately, having typed it in as it is written here, it doesn't actually return a value at all in cell I13, regardless of the values entered in cells F13 and G13. "Ed Cones" wrote: How 'bout =IF(ISNUMBER(G13),IF(G13=F13,"PAID",IF(G13<F13,"UN DERPAID","OVERPAID")),"") "Kevins" wrote: Stephen, thanks for the help. Here's the original formula. =IF(G13F13,"OVERPAID","PAID") I'm looking for the formula to only return a value in cell I13 if there is a value in G13. "Stephen" wrote: "Kevins" wrote in message ... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
Weird. It worked fine in my test spreadsheet, and I copied and pasted the
formula from the test to here to eliminate typos. I'd be happy to email the test spreadsheet if you'd like it. "Kevins" wrote: Ed, I think I see what this formula is designed to do unfortunately, having typed it in as it is written here, it doesn't actually return a value at all in cell I13, regardless of the values entered in cells F13 and G13. "Ed Cones" wrote: How 'bout =IF(ISNUMBER(G13),IF(G13=F13,"PAID",IF(G13<F13,"UN DERPAID","OVERPAID")),"") "Kevins" wrote: Stephen, thanks for the help. Here's the original formula. =IF(G13F13,"OVERPAID","PAID") I'm looking for the formula to only return a value in cell I13 if there is a value in G13. "Stephen" wrote: "Kevins" wrote in message ... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Blank cell
Great!
"Kevins" wrote: Ed, My error - it works very well if I actually point it at the correct cells! Thanks for the help. "Kevins" wrote: Ed, I think I see what this formula is designed to do unfortunately, having typed it in as it is written here, it doesn't actually return a value at all in cell I13, regardless of the values entered in cells F13 and G13. "Ed Cones" wrote: How 'bout =IF(ISNUMBER(G13),IF(G13=F13,"PAID",IF(G13<F13,"UN DERPAID","OVERPAID")),"") "Kevins" wrote: Stephen, thanks for the help. Here's the original formula. =IF(G13F13,"OVERPAID","PAID") I'm looking for the formula to only return a value in cell I13 if there is a value in G13. "Stephen" wrote: "Kevins" wrote in message ... Hello, I have a spread sheet which tracks whether an item has been paid or not. It also looks at the amount claimed and compares this to the amount paid and returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the amount paid cell is blank the status defaults to "PAID". Any ideas? It's easier if you post your formula. But try this (for amount paid in cell A1): =IF(A1="","",put_your_formula_here) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If cell blank return a blank | Excel Worksheet Functions | |||
| add blank space in cell if first name is not blank | Excel Worksheet Functions | |||
| how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Linear Mode
