Hello All,
Any help would be appreciated. I have a worksheet where column A is how much money came in Column B is the Fee Amount Column C is total PNA and Column D is PNA Adj. ( I have attatched a sample) I need a IF formula to say if COLUMN C which is TOTAL PNA doesnt total 150$ than COLUMN D which is the PNA ADJUSTMENT needs to add whatever amount is need to equal 150
so far i have =IF(C<150,150-C, ???)
Last edited by mstrezoska; 06-16-2011 at 04:31 PM.
How about = MAX(C4,150) ?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
I'm not sure exactly what you are asking. Hopefully this is what you needed.
=IF(C4<150, 150-C4,"")
Loppy
that would work but sometimes the TOTAL PNA does equal 150 so when you put that formula in the next column if also equals 150 which gives me a gross of 300.. I need the gross at the end to be 150 so if the TOTAL PNA is already 150 the adjustment shouldnt be anything but 0.
THANK YOU LOOPY! that works great, i just changed the "" to 0 and it works. I REALLY APPRECIATE IT!
Mstrezoska,
Did you try?
=IF(C4<150, 150-C4,"0")
Loppy
Good to hear.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks